Forum Discussion

Whats_a_profile_name's avatar
Whats_a_profile_name
Copper Contributor
Mar 23, 2023
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? ...
  • PeterBartholomew1's avatar
    Mar 23, 2023

    Whats_a_profile_name 

    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.

     

     

     

Resources