Previous Topic Next Topic

Conditional Formatting with dates

Closed
scarey3 Posts 4 Registration date Tuesday October 15, 2013 Status Member Last seen February 12, 2014 - Feb 12, 2014 at 03:42 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 16, 2014 at 11:36 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 16, 2014 at 11:36 PM
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.
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
encryption message several time in chat
measking -
HelpiOS -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response