Conditional Formatting Formula

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
Hi All,

I have a spread sheet where Column P has a date in it, I want to be able to highlight that column if the date is 14 days or more.

Example:

Column P: 17/07/12
Becasue it is now past 14 days from Column P it would be highlighted Yellow.

Can any one tell me the formula.

Thanks

Shazz
xx
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Use a cell value of less than a value of TODAY()-14
 
Top