Highlight a number of cells based on a count not value

[riddenstudios]

Hello to all,

I am truly stumped. I searched but couldn't come up with anything that works. I am trying to highlight a number of cells based on a count not values. In other words if A1 has a number 5. I would like A2:A6, next 5 cells, to automatically highlight. I would prefer something in VB if possible. It is important to realize there are no values in A2:A6 these are just based on the count given by A1.

Any help would be useful

Thanks,
Andrew

 

[Sixthsense]

Place the cursor in A2 cell and select all the downward cells and in Conditional Formatting Use the below formula

=ROW()<=($A$1+1)

 

[riddenstudios]

Ah, that proves i'm better at VB instead of formulas. But you are the master. Thanks works perfect!

 

[Sixthsense]

Glad it helps you and thanks for the feedback