Fill cells based on value

[hiwire03]

I am looking for a way to fill a number of cells in a row/column based on a particular cell's value. So, if a cells value is say 7 or 3, then 7 cells or 3 cells must be be filled with a particular colour.



Thanks in advance

[xor]

If A1=7 do you mean that A2:A8 must have a color, if A1=3 then A2:A4 must have a color and so on?

[hiwire03]

Originally Posted by xor

If A1=7 do you mean that A2:A8 must have a color, if A1=3 then A2:A4 must have a color and so on?

That is correct

[xor]

See the attached.

[hiwire03]

Great, very close to what I've been looking.
Except I would like to start the fill at a preferred cell.
Would appreciate if you could educate me on how to do it?

[hiwire03]

[xor]

Let's say you have value (7, 3 ot whatever) in A1 then you can use the following formula in Conditional formatting:

=ROWS(G$10:G10)<=$A$1 if you want to start in G10.
In the field Applies to can you write for example =$G$10:$G$100 if your max value in A1 will be 90.

You can use the Format Painter to copy that conditional formatting to another start cell (ensure that the formula has same row number both before and after the colon). Then you can go to the field Applies to and set the reference to what you want.