Conditional formatting with dynamic min and max

Hello, I need to design a report where I need to put a table which will show: 1. Date_time (Date and time when the record has been captured) 2. Value 1 3. Value 2 . . . 11. Value 10 Also I have min and max data fields for each value (i.e. Value1_min, Value1_max, Value2_min, Value2_max etc.) These values are dynamic as the values specs (min and max) are changing over time. The issue is that I need to add a conditional formatting in my table where: I put blue for values below min, white for the values within specs and red for the values above max. TI can only put manually the minimum and maximum numbers in conditional formatting which will not work for me as I will need to change the numbers every time the specs are changing. It would be much more easy to put a data field (i.e. Value1_min, Value1_max ) instead of a number in conditional formatting. Does anyone has any idea on how to overcome this??