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)
John,
I copied and pasted the example you provided, and it works fine for me, as long as cell B2 is exactly Success & Fail