Color field if date equals certain criteria

  • Thread starter Thread starter RC
  • Start date Start date
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.
 
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

Using Color as Criteria in Countif Function 3
Excel Excel due and overdue date colours 2
Excel Colour code dates 1
advanced filter date criteria 1
formula for high lighting rows 1
Date subtraction 1
Using datedif to format cell color 3
Conditional formatting based on dates 1

Back
Top