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

Todays date minus 1 5
Cobditional Formatting Rows based on dates in action plan. 0
formula for high lighting rows 1
advanced filter date criteria 1
Date subtraction 1
Need to auto-enter last updated date, only if another cell has changed 1
Using datedif to format cell color 3
Using Color as Criteria in Countif Function 3

Top