title: Conditional formatting for a column based on the value of header
body: <p>I have several columns where the data from rows 7 onwards changes depending on the selection made from a dropdown menu in row 6. Most of these options will result in textual or number based values appearing, but two of them would need to be formatted as currency.</p>
  
  <p>Essentially what I want is a conditional formatting formula that says; if row six in any column has a value of “Implied Unit Rate” or “Annual budget”, format rows 7 and onwards in that column as currency.</p>
  
  <p>I can get this to work by creating two separate conditional formatting formulas and applying them both to the whole area, but it seems like there should be a way to do it in a single formula.</p>
  
  <p>My current formulas, applied as two separate rules:</p>
  
  <p><code>=INDIRECT(ADDRESS(6,COLUMN(),1))="Annual Budget"</code></p>
  
  <p><code>=INDIRECT(ADDRESS(6,COLUMN(),1))="Implied Unit Rate"</code></p>
  
  <p>How I think it should work when applied as one rule:</p>
  
  <p><code>=OR(INDIRECT(ADDRESS(6,COLUMN(),1))="Annual Budget",
       INDIRECT(ADDRESS(6,COLUMN(),1))="Implied Unit Rate")</code></p>
  
  <p>When I enter the combined formula in a regular cell within the worksheet, it does return true as expected, but does nothing when I apply it as a conditional formatting rule. Any ideas? Thanks in advance!</p>