Conditional formatting based on formula Excel
<p>I am trying to create a rule for conditional formatting that highlights the column yellow if the header of the table contains the same value as is contained in cell A1, but it says my formula has an error.
Does anyone have any ideas?</p>

<p>Here is my formula:</p>

<pre><code> =CELL("col", INDIRECT(ADDRESS(ROW(), COLUMN()))) = (MATCH($A$1,Table1[#Headers],0)+2)
</code></pre>

<p>EDIT: The formula works when I put it into a cell, just not when I put it into the 'new rule' section of conditional formatting.</p>