https://www.dropbox.com/s/yqhqrz15glno6xt/Color Scale.xlsx?dl=0
I have eight rows of data and a average line for all eight.
I was to use the color scale against the average line.
So any of the 8 rows that are lower than the average would be on the good side (green.)
Any rows above the average would be on the bad side (red.)
But the average row shouldn't be colored, or it should be neutral if it was.
I have eight rows of data and a average line for all eight.
I was to use the color scale against the average line.
So any of the 8 rows that are lower than the average would be on the good side (green.)
Any rows above the average would be on the bad side (red.)
But the average row shouldn't be colored, or it should be neutral if it was.
