re: Complicated Excel Question - Is this possible?

I just tried it out on Excel, and I was able to do it, but yeah it seems like it would be time-consuming.

Under conditional formatting->more rules, change the format style to 3 color, set your value types to formula, and input the values as such:

Midpoint is average of cells.

Minimum is average minus absolute max deviation.

Maximum is average plus absolute max deviation.


Forgive me, but I am about to edit with a photo of a screen instead of an actual screenshot



I realize my values are on the same sheet, whereas yours would be spread across multiple sheets, but it should work the same. I just needed to show how the colors compare to one another.