Conditional formatting for heat map

[madelinemsharpe]

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.

Please help!

Thank you,

Maddie

 

[madelinemsharpe]

Ok, I think I understand...instead of using 3 color scale go to conditional formatting ... new rule....use a formula to determine which cells to format....then in the format values where this formula is true paste in the first formula click on format and select the color for the first rule.

you would repeat this process for the 3 rules, selecting your desired color.

remember to select the range prior to creating the conditional format if it doesn't stay selectled

It worked!! Thank you thank you!

 

[Weazel]

you're welcome, glad you got it working