Forum Discussion

john legge's avatar
john legge
Copper Contributor
Sep 18, 2018
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"  ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 18, 2018

    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)

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 18, 2018

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 legge's avatar
    john legge
    Copper Contributor
    Sep 19, 2018

    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

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 19, 2018

      So far so good

  • john legge's avatar
    john legge
    Copper Contributor
    Sep 18, 2018

    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?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 18, 2018

      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