Conditional Formatting not working with Data Validation (List)

[trillium]

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?

[ChemistB]

Something is different about your "Choose Cashlines" Can you upload the file (Go Advanced>Manage Attachments)?

[ChemistB]

Some tests, assuming Choose Cashlines is in A1

= LEN(A1) should be 16
= CODE(MID(A1,1,1)) should be 67
= CODE(MID(A1,16,1)) should be 115

[trillium]

Attached file with problem cell

It's actually B19 (the problem cell)

If it says "Choose Cashlines" it should be green, otherwise the blue.

I'm sure it's something really stupid I just can't seem to see!!!

[trillium]

Hi

When I did the LEN test I get 17, when the do the other tests I get the same values (67 and 115)

??

[trillium]

omg there was a space after Cashlines... that I couldn't see, but when I clicked into the cell after changing the dropdown list, it showed up! SO SORRY!!!!

[ChemistB]

No problem. That's the reason I suggested those tests. Glad you found the problem.