Excel conditional formatting

  Bee Jay S 20:06 06 Jun 07
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 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

  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

=TODAY()-A1>730

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac