Forum Discussion
Solved
Conditional formatting: cell fill depends on character and case
I want to set a cell's fill color according to its content's character and case. Something like: a Red A Orange b Yellow B Green c Blue C Purple What's a simple way to do this? ...
The function EXACT will also give a case sensitive match, so the conditional formatting could be based upon the formulas
= EXACT(B2,"a") = EXACT(B2,"A") = EXACT(B2,"b") = EXACT(B2,"B") = EXACT(B2,"c") = EXACT(B2,"C")which return TRUE or FALSE.
The function EXACT will also give a case sensitive match, so the conditional formatting could be based upon the formulas
= EXACT(B2,"a")
= EXACT(B2,"A")
= EXACT(B2,"b")
= EXACT(B2,"B")
= EXACT(B2,"c")
= EXACT(B2,"C")
which return TRUE or FALSE.
- I'm a stranger here so I don't know how to upvote or accept-as-answer or whatever it is one does in this forum. But your answer was clear, simple to use, and thoroughly demonstrated, so Thank You.
