Automatically change cell colors based on date in cell

  • Thread starter Thread starter Greg
  • Start date Start date
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
 
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
 
Back
Top