title: Apply conditional formatting in Google Docs if current cell exists in a range
body: <p>Very simply, I am attempting to highlight a cell if that cell matches (exactly) with a different cell from a different column (in a different sheet, specifically).</p>
  
  <p>For example, I have an 'Active' and 'Inactive' sheet in my Google Docs Spreadsheet.  Some of the items listed in 'Inactive' are also listed in 'Active', and I need to highlight those.</p>
  
  <p>What I've gotten so far is this (that doesn't work):</p>
  
  <ul>
  <li>Format -> Conditional Formatting</li>
  <li>Format Cells If -> Custom Formula Is</li>
  <li><code>GT(MATCH(A1, 'Active'!A2:A, 0), 0)</code></li>
  </ul>
  
  <p>The general formula above works if I use it in the spreadsheet normally and correctly pass the 1st parameter to <code>MATCH()</code>, however when I attempt to move the regular formula to a conditional formatting, it seems to break down: I need to pass the <em>current cell's contents</em> as the 1st parameter, not <strong>A1</strong> statically.  If using <code>GT()</code> + <code>MATCH()</code> is indeed the correct way to accomplish this, I need a way to express:</p>
  
  <pre><code>GT(MATCH(  'Inactive'! [A + ROW()]  , 'Active'!A2:A, 0), 0)
  </code></pre>
  
  <p>... Where A+ROW ends up being the non-literal expression, -- i.e. on row 123 this would refer to the cell contents of A123.</p>
  
  <p>There may be also an easier and more intuitive way to do this altogether.  To state my problem in a different way, "If the current cell's data [a string] is present (or 'matches') in the range <code>'Active'!A2:A</code> then highlight it".  </p>