Hello from Steved

Please how does one go about highlighting every second row please using a
light grey.

from A3:C3, to A5:C5, to A7:C7, and so on I've got 3,450 rows to do.

Thankyou.

Select A3:C3 and highlight light grey.

Select A3:C4 and selct Format Painter tool (next to Paste on standard
toolbar)

Select A5:C3450

Done!

Chip Pearson has a web page on this subject:

http://www.cpearson.com/excel/banding.htm

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Steved" wrote in message
...
Hello from Steved

Please how does one go about highlighting every second row please using a
light grey.

from A3:C3, to A5:C5, to A7:C7, and so on I've got 3,450 rows to do.

Thankyou.

Thankyou

"Steved" wrote:

Hello from Steved

Please how does one go about highlighting every second row please using a
light grey.

from A3:C3, to A5:C5, to A7:C7, and so on I've got 3,450 rows to do.

Thankyou.