conditional formatting with formula

I have a conditional format set up that if D5=TRUE to highlight cells B18:D20 yellow. Now I want to be able to have those cell to NOT be highlighted when text is entered into them. So basically, IF...

Formatting

PReagan
Aug 28, 2019
Hello kdwork,

Something like this should work:
In cell B18, create the conditional formula:
=B18<>""
Format this to no highlight, applies to =$B$18:$D$20, check the box under "Stop If True"

In cell B18, create the conditional formula:
=$D$5=TRUE
Format this to highlight yellow, applies to =$B$18:$D$20, do not check the box under "Stop If True"

Finally, make sure the format with no highlight is above the format with highlight yellow.

Hope this helps!
PReagan