If the cells should turn green if their value is <= minimum of the range PLUS a value between 0 and 1.99% of that value, the formula is: =and(G3:N3<>"",G3:N3<=101.99/100*min ($G3:$N3)) if they have to turn red, the formula is: =and(G3:N3<>"",G3:N3>=102/100*min ($G3:$N3)) no color if the cell is empty [![colors][1]][1] [1]: https://i.sstatic.net/2D4gz.png