Conditional Formatting Colour Scales Based on Divergence from Another Cell

[andybason]

Hello

I have a series of "standard" values in row 1. In rows 2-10 I have some test results which may be higher or lower than the standards. I would like to use conditional formatting to generate a colour scale based on how much the values in rows 2-10 diverge from the standard values.

Is this possible? I just can't seem to find any guidance on how to do this.

Thank you

 

[Joe4]

I have never done anything like that, but perhaps this old thread will help:

Formula in conditional formatting

Hi, I am trying to use conditional formatting to highlight different % ranges in cells. To explain: I have a grid of data with name of entity down the left vertical axis and 5 different time periods along the horizontal axis. This means be looking at entity A and time period 1 Day I can see...

www.mrexcel.com