Solved: cell formatting row wise

[ilyaskazi]

In my activesheet do cell formatting row wise...

1) Select first row, fill grey color

2) Select second row, fill light green color

3) Select third row, fill grey color

4) Select forth row, fill light green color

and like wise to all rows upto data is found in its last rows.

[mdmackillop]

Unless you really need code, or you have other unwanted formatting, colour the first two rows manually, select the first two rows, click on FormatPainter and drag down with the fill button.

[ilyaskazi]

No, i require through vba only to apply until last row of data is found of column A

[ilyaskazi]

anyways, i hv solved myself.

thanku for guiding. It helps to write code.