Google sheet - Formating another cell, based on drop-down
<p>I have <strong>two columns</strong> A and B</p>

<p>I'm trying to format A based on drop-down selection from B</p>

<p><strong>I did:</strong> </p>

<pre><code>"Custom formula is":  =$B:$B="Waiting" 
Background Color:     red 
Range:                A:B
</code></pre>

<p>but it does not seems to work unless I write "Completed", in stead of having a drop-down in the B cell.</p>

<p>Does that mean, drop-down is not supported in this case?
<a href="https://docs.google.com/spreadsheets/d/1xWijibYk__jHku9UIi4tIjIb607wSbfDbdCj8K2-gt4" rel="nofollow">https://docs.google.com/spreadsheets/d/1xWijibYk__jHku9UIi4tIjIb607wSbfDbdCj8K2-gt4</a></p>