Forum Discussion
cell between two number values results in color change of a neighboring cell with certain value.
I need help, I am a beginner to formatting in excel and we want to change the color of cell I2 if the value of cell H2 is between two numbers. We have a spreadsheet at work where we enter lab results...
You didn't specify what and how to color. As variant
with rule formula
=($H2>=10.5)*($H2<11.1)*($I2>=9) +($H2>=11.1)*($H2<11.5)*($I2>=8.5) +($H2>=11.5)*($I2>=8)
