Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using CF to change colour in cell based on date?
I would like to use Conditional Formating to change the colour of one cell
depending on the date of another cell. What I mean is say I put a date (e.g. 31 Mar 10) in cell F11 and want to add 5 years onto that date and have that cell (cell G11) give me the new date with the cell colour of green. As the time counts down have the cell turn yellow, say one year before the end of the 5 year date, and then turn red once the 5 year date has expired. What formulas do I use to produce this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i change cell text colour based on value in other cell | Excel Worksheet Functions | |||
change cell colour according to date..... | Excel Worksheet Functions | |||
Change colour based on date | Excel Worksheet Functions | |||
past date cell colour change | Excel Worksheet Functions | |||
Change cell colour by date | New Users to Excel |