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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Automation of scanned file storage based on content 0
Assigning a value to one cell based on the date in another... And then doing it again 0
Can a cell be changed on a certain date 2
Using CF to change colour in cell based on date? 4
"If" function and Upcoming Dates 1
Conditional Formatting in Excel 2003 2
Conditional Formating based on Date 5

Top