I have 60 correlations and right now I am just using one of the Color Scale Conditional Formatting that will shade the lowest numbers in red and teh highest in green...what I want do is have a formula so that the closest numbers to zero are highlighted green and the farther you get away from zero (negative or positive) will be red....So i figured if the formula used Absolute values then it would just be the numbers closest to zero would be green and farther away would be red. Eitehr way I am trying to illustrate the best correlations in a color shade vs. the crappier ones.