Need help I want to color cells red based on a measured value

[jmetz]

I have a large number of measurements to make at different levels, I want to color a cell red if the measured value is not within the tolerance. The problem is each tolerance changes based on a Minimum value, and each % value has a different tolerance. Please see the My_Example spreadsheet I have attached. In this example the Minimum is .24 so for 20% the target is 2.10 +/- .10 (color cell red if value is <2.0 or > 2.2), for 50% target is 1.10 +/- .11 (color cell red if value is <.99 or > 1.21), same for 80% Target is .52 +/- .05. If the Minimum changes so do the Target values and the /- Tolerances. I am not sure If this can be done with a formula or maybe I need to write a macro, I am fine with either solution any help would be greatly appreciated. Thanks

[protonLeah]

Please Login or Register  to view this content.

DMin = Cell B1

[jmetz]

Thank you for cleaning up my worksheet your solution works very well. I have one question how do you get the blue/green fill color to follow the Dmin entry to Cells A11:G13? That is a nice touch I can't figure out how that is working.

Thanks

Jim

[jmetz]

Please disregard my last post I did not notice the conditional formatting in those cells. Thanks Again

[jmetz]

I wonder if you could help me once again, I would like to add a seond table label Dmin2 that could use a separate Dmin2 value from Dmin1. I can't figure out how Dmin is tied to cell b1 and be able to change it to f1 for the secong table, I have attached an example.

Thanks

Jim