Hi Bill

You could use an AND() statement wrapped around Bob's solution.
=AND(NOT(ISBLANK(A$1000)),DATE(YEAR(TODAY()),MONTH (TODAY())-A$1000+1,DAY(TODAY())))

Regards

Roger Govier


Bill Foley wrote:
Sure enough worked as well. THANKS!

One last thing - Any idea how to skip blank cells in a range (or have an IF
statement that only does the conditional formatting if the cell has a date
in it)?