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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting / Formula 6
Conditional Formating based on Date 5
[Flashing] RED before renewal date 1
several conditional formats for dates 4
Coditional Format 4
Trouble w/ conditional formatting and dates 5
Conditional Format - Due Dates - 2 questions (2nd posting) 2
conditional format cells by date 2

Back
Top