Forum Discussion
Solved
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...
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
