Conditional Formatting with dates [Closed]

Report
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello, Your help would be greatly appreciated

I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is met

If todays date is 7 days before cell A1 then colour Orange
If todays date is greater than A1 then colour Red
If todays date is more than 7 days before cell A1 then colour Green

Thank you

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
if yours is excel 2007

donwoad file from

http://speedy.sh/FbNfe/scarey-140217.xlsx

save it
goto home ribbon conditional formatting(xl 2007)
click manage rules (last iems) and see the formulas and formats.