Conditional Formats XL2007

  • Thread starter Thread starter Telford Tom
  • Start date Start date
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
 
Try the below formula instead which will validte blanks.

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

If this post helps click Yes
 
Back
Top