I am trying to make a spreadsheet for checking supply voltages. The sheet changes the local supply voltgage dependant on the country selected. You are then shown the +/- tollerence for the supply. This then gives me a cell to put the actual value in H1, the expected value in I1 and then the low and high tolerence in J1 & K1 respectively.
I am trying to somehow conditionally format the background colour of H1 depending on its value with if H1=I1 then it would be green and then change colour gradually to red if I head towards the limits. It would then remain red if over the limit.