copy cells (x) number of times

[xxentric]

im not sure how to go about this macro really...

if i would have conditional formatting in cells A4 B4 C4 and i wanted to copy that conditional formatting into a certain number of rows below (like an auto-fill) determined by what the user enter in cell A1... so say in A1 the user enters "6" and then runs the macro, it would copy the formatting into A5 B5 C5, A6 B6 C6, A7 B7 C7.... and so on....

 

[SkipVought]

Hi,

Turn on your macro recorder and record using the Format Painter to copy the CF format to whatever cells.

Observe your code and modify as needed.

Post back with your recorded code with your questions.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]