May 07 2020 03:37 PM
May 07 2020 03:43 PM
May 10 2020 04:11 PM
@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
May 10 2020 07:05 PM
Solution@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
May 13 2020 05:06 AM
May 13 2020 05:11 AM
May 10 2020 07:05 PM
Solution@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