title: How to apply a formula to an entire sheet for every row
body: <p>I have a problem applying a formula to an excel sheet.</p>
  <p>I need to pick an entire row and change it's color depending on the value of the cell &quot;E&quot; in that row. This rule should apply to the entire sheet.</p>
  <p>So, if I'm in row 3 and E3 is greater than 0, the entire row should be green. If I'm in row 7 and E7 is greater than 0, the entire row should be green, and so on...</p>
  <p>If I use this formula: =($E:$E)&gt;0 for $1:$1048576 range, it changes de color for all cells in the entire sheet using only cell E1 value</p>
  <p>How can I do this? I'd appreciate your help</p>