title: Conditional Formatting in different sheet
body: <p>I have a 13x13 table of data on a worksheet that is comprised of links to another sheet.</p>
  
  <p>For example the first row of 13 looks like:</p>
  
  <pre><code>=Sheet1!R7  =Sheet1!R20 =Sheet1!R21 =Sheet1!R22 =Sheet1!R23 =Sheet1!R24  =Sheet1!R25    =Sheet1!R26 =Sheet1!R27 =Sheet1!R28 =Sheet1!R29 =Sheet1!R30 =Sheet1!R31
  </code></pre>
  
  <p>I want to do conditional formatting over the entire table for when data from column R and column C of the same row are equal and >0.</p>
  
  <p>For example;</p>
  
  <p>When Sheet1!R7 is equal to Sheet1!C7 and >0, color the sheet 2 table (that has the link) red.</p>
  
  <p>When Sheet1!R20 is equal to Sheet1!C20 and >0, color the sheet 2 table red and so on.</p>
  
  <p>I would also like to repeat the process with a different colored fill if R == L and >0 but I can just use the same formula once I know how.</p>
  
  <p>My attempt was =AND(Sheet1!R7=Sheet1!C7,Sheet1!C7>0).</p>
  
  <p>This works for the single cell, but I'd like a way to do the whole table at once. </p>
  
  <p>Any help is appreciated, thanks.</p>
  
  <p><strong>EDIT for clairty:</strong></p>
  
  <p>*I'm sure I'm not explaining it too well.</p>
  
  <p>To put it simply, I have 2 columns of numbers, let's say A1:A169 and B1:B169.
  I want to take the larger number from A and B for each row (A10 vs B10 etc, I used MAX function for this) and dump the output in column C.</p>
  
  <p>I then aim to color code column C based on whether the number comes from column A or B. Red for A, yellow for B (no color for &lt;0).</p>
  
  <p>So far I have achieved all of this, I have the data sitting in a column color coded.</p>
  
  <p>My problem comes in that I want to have the 169 numbers in column C in a more readable format, I.E. in a 13x13 grid table. I don't know how to do this and keep the color coding!*</p>