Excel conditional formatting

  Bee Jay S 20:06 06 Jun 2007
Locked

I have a spreadsheet with training dates, using conditional formatting I would like to enter a formula to highlight a cell when two years have passed since the last training date.
Hope that makes sense!
Thanks

  Noldi 20:12 06 Jun 2007

I can give you a bit of aroundabout way but im sure there is easier.
=Today() in a cell then minus that from the dates that refer to the traing date and format that when the answer is more the 730 (365 x2)

Noldi

  Noldi 20:12 06 Jun 2007

Sorry should be
is more than 730

  VoG II 20:13 06 Jun 2007

With training date in A1 Format > Conditional Formatting select Formula Is and enter

=TODAY()-A1>730

Then set the format and OK your way out.

  Bee Jay S 20:18 06 Jun 2007

Thanks for the quick response

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?