If you can see my latest file attached. The first thing I want to do is to choose the temperature (95,RT,-40) in column A. When choosing the temp I change the requirement for column E.

For example A3 is -40. The value added in E3 is 0.200. This means that the value is within the critera.

On the other hand we have A15 (95), the value added in E15 is 0.504, this value does not meet the criteria and should be colored.

What you can see in sheet3 is just an attmept to solve the problem.
If you have any other suggestions I'm all for it.

I'm not even sure if I answered your question right now.