Conditional Formats XL2007

T

Telford Tom

Sorry, it must be me. This didn't work, things just went straight to Red even
though they're not out of date. In the formula =TODAY()-A1>=90 should I be
typing anything in between the brackets?

Telford Tom
 
J

Jacob Skaria

Try the below formula instead which will validte blanks.

=AND(A1<>"",TODAY()-A1>=90)

If this post helps click Yes
 
Top