The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

The problem is this: variance from the zero point is what I am trying to color code, not highest and lowest values, i.e. a cell with a value of -.25 would be a larger value (i.e. a larger variance ...