Forum Discussion
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 D5=True, turn cells yellow, then if data is entered, turn off highlight. Is this possible as a conditional format, or do I need to utilize another method?
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
3 Replies
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
