Forum Discussion
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" I assume it objects to the & in the quotes but in this case & is just another character in the string. Can anyone help please
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)
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
Than
SergeiBaklan wrote: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)
ks All good nowJohn
So far so good
John,
I copied and pasted the example you provided, and it works fine for me, as long as cell B2 is exactly Success & Fail
