Wardylewis
New Member
- Joined
- Jun 7, 2016
- Messages
- 37
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.
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.