title: Color cells by absolute value in a range in Excel 2010
body: <p>I'm looking to color a table of values in Excel 2010 by their absolute value. Basically, if I have the table:</p>
  
  <p><img src="https://i.stack.imgur.com/Aa4a3.png" alt="enter image description here"></p>
  
  <p>...the cells are colored by the cell's raw value. What I would like to do is color by the cell's <strong><em>absolute</em></strong> value, so with the cell coloring of this table:</p>
  
  <p><img src="https://i.stack.imgur.com/f5rrz.png" alt="enter image description here"></p>
  
  <p>...but with the values of the first table (the real values). Any ideas on how one might do this? Through the GUI or with VBA?</p>