Color field if date equals certain criteria

R

RC

I have a list of dates in column A.
I have todays date in cell C1.
I want the date fields in column A to turn amber when they are equal to or
less than 15 days from todays date, then red when they are overdue.
Whats the formula for this please.
 
M

Mike H

Hi,

Select your range then

Format|Conditional format
Select formula is and enter the formula
=AND(A1<=TODAY(),A1>TODAY()-15)
Pick amber
Click ADD
Select formula is and enter the formula
=A1<=TODAY()-15
Pick red

You don't need to use the date in C1

Mike
 

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

formula for high lighting rows 1
Excel Colour code dates 1
advanced filter date criteria 1
Using datedif to format cell color 3
Excel Excel due and overdue date colours 2
Using Color as Criteria in Countif Function 3
Return to todays date macro 4
Question on conditional formatting & email macro 9

Top