Hi all,
I have a column on my worksheet that has conditional formatting. (col F in the attached example). If the date is in the past, the cell is red. If the date is due in 7 days, the cell is yellow. That bit is working fine. What I want to do is clear that formatting if column G has the word "Implemented" in it. I actually want to put the old fill colour (the same as in col E) if col G is implemented.
I hope that makes sense!
Bookmarks