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