title: google sheets conditional formatting across sheets [range trouble]
body: <p>I need to format a range of cells in <code>Sheet1</code> according to values in <code>Sheet2</code>. Explicitly, Cell <code>Sheet1!B2</code> must be formatting according to value in <code>Sheet2!B2</code>, <code>Sheet1!C10</code> according to <code>Sheet2!C10</code> and so on...</p>
  <p>This Conditional formatting formula works just fine:</p>
  <ul>
  <li>RANGE: <code>Sheet1!B2:B</code></li>
  <li>FORMULA: <code>=INDIRECT(&quot;Sheet2!B2:B&quot;)&gt;100 (works fine, cell-by-cell)</code></li>
  </ul>
  <p>But when I expand the range to something like the below, it formats nothing anywhere... It doesn't work:</p>
  <ul>
  <li>RANGE: <code>Sheet1!B2:C</code></li>
  <li>FORMULA: <code>=INDIRECT(&quot;Sheet2!B2:C&quot;)&gt;100 (does nothing in either column B or C)</code></li>
  </ul>
  <p>When I try the below it formats &quot;by line&quot;, <code>Sheet1!B2:C2</code>, <code>Sheet1!B10:C10</code>, etc for instance:</p>
  <ul>
  <li>RANGE: <code>Sheet1!B2:C</code></li>
  <li>FORMULA: <code>=INDIRECT(&quot;Sheet2!B2:B&quot;)&gt;100</code></li>
  </ul>
  <p>I need formatting &quot;by cell&quot;, for example <code>Sheet1!B2</code>, <code>Sheet1!C10</code>, and so on.</p>