Hi

I can't find a solution to this problem. I have a Data Validation List and would like to apply conditional formatting to the cell depending on what the user has selected from the list.

My other CF are working fine off other data validation lists, but this one will not work no matte what I do!

The choices are "Choose Cashlines, EHC, STD, Dental"

If the cell shows "Choose Cashlines" then I want the colour to be green. Otherwise it's blue.

I can get it to turn blue fine, but no matter what I do, it will not turn green if the cells is showing "Choose Cashlines".

I've checked to be sure there are no spaces, I've physically copied the text from the cell into the formula, I've even tried to add a formula switch in an adjacted cell (IF(A1="Choose Cashlines,1,0) but it is also not recogzining it?? I've used this for other entries in DV lists and it always has worked fine.

Any thoughts?