It’s taking forever to conditionally format every cell.
I want to be able to do say 20 cells vertically, with only the number changing.
For example I2 should be $I2 < 5
I3 should be $I3 < 5
And so on and so forth.
Can I do say 20 of these all in the I column at once?
Just mark the cell range I2:I12 (for example), invoke conditional formatting and use the condition Cell value is with less than and in the edit field enter 5
That did partially work, cells I2:I22 accepted the cell range for I2:I22.
But I wanted H2:H22 to also have the same style effected on them that happens to I2:I22.
If you highlight H2:H22 and change the Cell Range from H2:H22 to I2:I22 then nothing happens.
If it helps H contains the name of the item’s, I contains their quantity, anything under 5 has a red background, under 50 has a yellow background and so forth.
I want the background of H and I to be effected by the numbers entered in I.
You didn’t say that, so…
Starting at H2 select the cell range H2:H22 and in conditional formatting choose Formula is and enter $I2<5
$I2 will automatically become $I3 in H3 and so on.