Formula please to highlite every second Row.

[Guest]

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.

 

[soxcpa]

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!

 

[RagDyer]

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!
==============================================

 

[Guest]

Thankyou