Forum Discussion
Conditional formatting not working
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 pink
And so on for lots of leave types. I had managed this and it works fine on 1 spreadsheet but when using it on another the AL PM stays white.
Im am selecting cell = to and then the above in 3 seperate rules.
I found it worked on a small range but not when i extended it.
Thanks in advance.
Diane
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
5 Replies
- sometimes the ranges and cell references can get messed up. double check that the 'applied to' range in the conditional formatting is still correct. otherwise, maybe send the file or screenshots or something for us to go by
mtarlerThanks for your reply, sorry mine is so late, I have a very small baby. I have double checked it against the spreadsheet that actually works and still cant see where I have gone wrong. The only change I have made since it worked is add a column after every column and an overview page to calculate totals.
If you could have a look at the attached that would be a great help.
Thanks
Diane
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
