DarkoDeign2
Board Regular
- Joined
- Jun 20, 2023
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi,
I have conditional formatting of cells A2 to G2 (change fill color to blue if H2 contains the word "Stop".
Formula for formatting =$H2="Stop"
Applies to range =$A2:$G2
But what can I do to have the cell G2 to keep being blue even if H2 no longer has the text "Stop"?
Should I have a separate conditional formatting formula on for cell G2?
I have conditional formatting of cells A2 to G2 (change fill color to blue if H2 contains the word "Stop".
Formula for formatting =$H2="Stop"
Applies to range =$A2:$G2
But what can I do to have the cell G2 to keep being blue even if H2 no longer has the text "Stop"?
Should I have a separate conditional formatting formula on for cell G2?