Conditional formatting where two columns in a table are not the same
<p>I have a table called <code>promos</code> containing 2 columns <code>existing mechanic_code</code> and <code>new mechanic_code</code>. I want to format the values in those columns accordingly if they are not equal.</p>

<p>I tried this</p>

<pre><code>=INDIRECT("promos[existing mechanic_code]")&lt;&gt;INDIRECT("promos[new mechanic_code]")
</code></pre>

<p>in my Conditional Formatting formula but it didn't have the desired affect. It evaluated to true for all cells (i.e. coloured them all red):</p>

<p><a href="https://i.stack.imgur.com/gsc6m.png" rel="nofollow"><img src="https://i.stack.imgur.com/gsc6m.png" alt="enter image description here"></a></p>

<p>Here is an example of exactly what I mean: <a href="https://1drv.ms/x/s!AjcmU60daA9VqsRFaZzng_w1gP_EWQ" rel="nofollow">https://1drv.ms/x/s!AjcmU60daA9VqsRFaZzng_w1gP_EWQ</a></p>

<p>I only want to highlight rows where the two columns are different.</p>

<p>Anyone know how to solve this?</p>