title: How to Replace Text in a cell Using Conditional Formatting
body: <p>Let's say that in my Column A, I have a dropdown menu for "YES" and "NO".</p>
  
  <pre><code>If A1 == "YES"
     B1 = "CONGRATS!"
  If A2 == "NO"
     B2 = "SORRY!"
  </code></pre>
  
  <p>I have applied the code below in column B's conditional formatting but didn't worked. Any possible option?</p>
  
  <pre><code>=IF(A1&lt;&gt;"YES", "SORRY","")
  </code></pre>