Forum Discussion
Solved
Problem using & symbol in conditional formatting with a formula
I have conditional formatting with a formula working for strings of text no problem. eg =$b2="Success" but when I use in the quotes a & character it does not work for example =$b2="Success & Fail" ...
Hi John,
It works if you use as vertical quotation mark symbol CHAR(34), not soft curve quotation mark (or how it called in English), CHAR(147)
Thanks Sergei. I am sorry but where is the vertical quotation symbol on a keyboard. I assume the soft curve is above number 2 but that is not correct in this case?
John, you may copy your formula without "=" to the cell and check symbols like this
Another reason could be if the range to which you applied the rule starts not from B2, but from another cell