- Sep 16, 2014
I am trying to set up a heatmap in excel 2007 using conditional formatting. I need all ABS(2.5) and above to be red, all values between ABS(2.4) and ABS(.99) to be yellow and all values less than ABS(1) to be green. I cannot figure out the right equation for my middle criteria (yellow) and also I cannot get excel to recognize the negative numbers. For example it keeps showing all the negative numbers as green.