Automatically change cell colors based on date in cell

G

Greg

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
 
S

Sheeloo

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
 
Top