| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically change cell colors based on date in cell
Use CONDITIONAL FORMATTING
go with the option FORMULA IS and use something like =(Today()-A1)30 which will be true if the date in A1 is more than 30 days in the past "Greg" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically change cell colors based on date in cell
You can try Conditional Formatting, Click on Format in your Toolbar, and
select condtional Formatting. in there you can format the cell to be a certain color if it falls into a certain Criteria. try that. "Greg" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
