Ask Your Question

Bulk Conditional format

asked 2017-06-26 14:34:20 +0200

arminius743 gravatar image

updated 2017-06-26 14:34:54 +0200

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-26 14:45:18 +0200

erAck gravatar image

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

edit flag offensive delete link more


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.

arminius743 gravatar imagearminius743 ( 2017-06-26 15:50:40 +0200 )edit

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.

erAck gravatar imageerAck ( 2017-06-26 19:33:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-26 14:34:20 +0200

Seen: 58 times

Last updated: Jun 26 '17