I need to format my cells to change colour 5 days after date

January 15, 2012 at 03:33:22
Specs: Windows 7
I need to format my cells in excel to change colour 5 days after date entered.

See More: I need to format my cells to change colour 5 days after date

Report •


#1
January 15, 2012 at 07:45:18
With your Date Enterd in cell A1 try:

=(A1+5)<=TODAY()

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question