Conditional formatting for adjacent cell

[CJG19]

Hi All,

Just a really easy one, I am sure! I just cannot seem to get my conditional formatting to work.

If todays date is 2 weeks after the date in column c then highlight column d in red but if there is nothing in column c I would like no formatting at all.

TIA!

CJG19

 

[Joe4]

Use this Conditional Formatting formula for cell D4

=AND(C4>0,TODAY()-C4>14)

 

[CJG19]

Amazing, thank you Joe4, I was getting confused with ISBLANK functions!

 

[Joe4]

You are welcome!

One key is to understand that Excel actually stores dates as numbers (specifically, the number of days since 1/0/1900).
So you can use mathematical operators in date calculations.