Michelle has attended:
Excel Intermediate course
Conditional formatting
thanks Atlas, this hasn't worked for what i require, sorry i wasn't clear enough. I have a column of expiry dates these are all different dates. i want the cell to turn amber once the expiry date -60 days is reached and then change to red once the expiry date itself is reached and stay red unless date is manually changed.
RE: conditional formatting
This can be done using 2 separate conditional formatting rules.
First, select the entire column that contains your dates. Then go to 'Conditional Formatting' > 'Highlight Cell Rules' > 'Between'.
Select the colour to be amber, and enter a rule of between '=Today()-120' and '=Today()-179'.
Then add another between rule. Colour it red, and this time enter the rule as between '=Today()-180' and '=today()-300'
