Excel conditional formatting

  Bee Jay S 20:06 06 Jun 07

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!

  Noldi 20:12 06 Jun 07

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 20:12 06 Jun 07

Sorry should be
is more than 730

  VoG II 20:13 06 Jun 07

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


Then set the format and OK your way out.

  Bee Jay S 20:18 06 Jun 07

Thanks for the quick response

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…