| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically change cell colors based on date in cell
Does anyone know if it's possible to have excel automatically change the
color of a cell based on a date? I have to keep track of a large amount of ID and permit expiration dates, and right now I have to go thru them every month and change the colors myself. Red is for expirations within 3 months, yellow for 4-8 months, and green for 9 months or longer. This makes it easier to identify which are expiring sooner. I was trying to see if excel could do this automatically based on the date in the field and the date on the system. Thanks, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Can a cell change colors when the date entered arrives? | Excel Discussion (Misc queries) | |||
| How to have row color change based on one cell to 4 colors | Excel Discussion (Misc queries) | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions | |||
Threaded Mode
