Color cells by absolute value in a range in Excel 2010 -
i'm looking color table of values in excel 2010 absolute value. basically, if have table: ...the cells colored cell's raw value. color cell's absolute value, cell coloring of table: ...but values of first table (the real values). ideas on how 1 might this? through gui or vba? i don't think there way 3 colors (red, yellow, green), can 2 colors (for example yellow , green). make color low value , color high value same. way, cells lower absolute value have middle color , cells higher absolute value have other color. select data conditional formatting color scale more rules select "3-point scale" under format style change colors maximum , minimum colors same