Conditional format based on # of days from date entered

sburkhar

Active Member
Joined
Oct 4, 2006
Messages
363
I'm attempting to have my date turn red if 14 days have passed. I'm failing miserably.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

adam087

Well-known Member
Joined
Jun 7, 2010
Messages
1,356
You can set up a conditional format to look something like<today()-14<today()-14

Code:
=A1 &LT; TODAY()-14


/AJ</today()-14<today()-14
 
Last edited:

sburkhar

Active Member
Joined
Oct 4, 2006
Messages
363
I thought about that, but I have some dates in there from April. I want the date to turn red if 14 days have passed from that date.
 

adam087

Well-known Member
Joined
Jun 7, 2010
Messages
1,356
Sorry. I'm confused now. Dates in April would correctly turn red based on the above formula. Otherwise, what date are you comparing against?

/AJ
 

Watch MrExcel Video

Forum statistics

Threads
1,109,488
Messages
5,529,164
Members
409,852
Latest member
Perry123
Top