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)
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 now
John
So far so good