Forum Discussion

diseydaly1983's avatar
diseydaly1983
Copper Contributor
May 07, 2020
Solved

Conditional formatting not working

Hi there. Im looking for help with my conditional formatting. Im creating a leave planner and i want all of the same type of leave to be the same colour. So AL in pink AL AM in pink AL PM im pin...
excel
  • mtarler's avatar
    mtarler
    May 11, 2020

    diseydaly1983  Your problem is that the data validation is pointing to the Overview sheet where the value for "FL" is actually "FL " (notice the space at the end).  Then the conditional formatting is set as Value = "FL" and "FL" does not exactly = "FL ".

    I recommend using the "Specific Text" "Starts With" option or "Contains" option

     

diseydaly1983's avatar
diseydaly1983
Copper Contributor
May 13, 2020
Thanks very much. Im not great on excel but when i know something can be done i like to try.
mtarler's avatar
mtarler
Silver Contributor
May 13, 2020
glad I could help and it always good to try, because that is how we learn.

Resources