Forum Discussion
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...
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 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
Thanks very much. Im not great on excel but when i know something can be done i like to try.
- glad I could help and it always good to try, because that is how we learn.