| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell color if date exceeds formula
Hi,
I want to be able to change the cell color from a default (say green) to red when a date is past the date range specified. ie a cell would red todays date and then the adjacent cell would have a IF formula that would specify a date (say 14 days) after the first date. The cell would be green but when those 14 days are up they would change to red. I know it can be done... but how ! thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to change color of a cell when date is over a year old? | New Users to Excel | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| cell color change based on due date | New Users to Excel | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
Threaded Mode
