Conditional Formatting Dependent on Dates

[emw2368]

Hi,

I have 2 date columns in my worksheet, E and F. If 14 days have passed from the date entered in column E and there is no value in column F I would like the cells in column F to turn red. I tried to use the below formula but it doesn't seem to be working. Also when I click and drag the formating to cells below it retains the row number rather than updating to it's own row number


=AND(F2="",E2<today()-14)

Any help is much appeciated.

Thanks!

Edit:
Formula is =AND(F2="",E2< TODAY()-14)
</today()-14)

 

[emw2368]

EDIT: Formula did not post properly, it should have been =AND(F2="",E2<TODAY()-14)

 

[Fluff]

Are you sure that the dates in col E are real dates?
Select col E & format as general, what do you see?

 

[Joe4]

EDIT: Formula did not post properly, it should have been =AND(F2="",E2

See here: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[emw2368]

Are you sure that the dates in col E are real dates?
Select col E & format as general, what do you see?

Hi,

The dates revert to numbers when I do this. The formula is working, but it is also filling F blank for blank rows. This is problematic as we use this worksheet to track cases(we expect 2000+ for 2019) so I will have to apply this formula to 2000+ cellsand then fill them out as time goes by. I’d like the cells to be white until thereis a case attached to that cell row. The case number is in column B.
Is there a formula that will turn F red if blank when todayis >14days from row E, but only when there is a value in column B?

 

[Fluff]

Try
=AND(B2<>"",F2="",E2< TODAY()-14)

 

[emw2368]

Try
=AND(B2<>"",F2="",E2< TODAY()-14)

Thank you so much!! This is the second time you’ve really helped me, it’s greatlyappreciated

 

[Fluff]

Glad to help & thanks for the feedback