How to Replace Text in a cell Using Conditional Formatting
<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>