Basic Conditional Formatting

[Wardylewis]

Good Afternoon,

I am currently attempting to update a spreadsheet with conditional formatting. However I am becoming stuck with a simple problem.

We have a column which has the date a letter is received which starts at E7 we then have another column which states when a letter has been responded to which starts in F7.

Basically I have managed to set the sheet to say if E7 date received exceeds 14 days to turn red. What I am after now is that if any date is entered in F7 then the conditional formatting stops.

I hope somebody can help.

Lewis.

 

[Wardylewis]

Hi Joe,

That’s perfect thank you for your patience it is greatly appreciated.

Lewis

 

[Joe4]

You are welcome.
Glad we got it all working for you!