Conditional formatting--different formatting depending on cell con

  • Thread starter Thread starter Tammy S.
  • Start date Start date
T

Tammy S.

I would like to format a date cell when the date will expire in 15 days. If
there is no date, I don't want any formatting. How can I set the formatting
to meet both of these conditions?
 
Choose FORMULA IS and enter the formula
=AND(A1<>"",(A1-TODAY())<15)

It will higlight cell A1 if it contains a date which falls within the next
15 days (including dates in the past)

If you want to highlight dates only in the next 15 days use
=AND(A1<>"",(A1-TODAY())<15,(A1-TODAY())>0)
 
Sheeloo,

Perfect. Worked better than what was already there and the temporary
work-around I came up with. Thank you very much.
 
You are most welcome.

Thanks for your feedback.

Tammy S. said:
Sheeloo,

Perfect. Worked better than what was already there and the temporary
work-around I came up with. Thank you very much.
Click to expand...
 
Back
Top