Hi,
Here is my scenario.
Column A contains a short date eg 01/12/2011
Column B has a formula that adds 365's to column A
I would like to insert conditional formatting into Column B as follows :
If the current date is within 30 days of the date in column B then the cell needs to turn Yellow.
If the current date is past the date in Column B it needs to turn red.
Bookmarks