software

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:

www.cpearson.com/excel/banding.htm

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Stevedquot; gt; wrote in message
...
gt; Hello from Steved
gt;
gt; Please how does one go about highlighting every second row please using a
gt; light grey.
gt;
gt; from A3:C3, to A5:C5, to A7:C7, and so on I've got 3,450 rows to do.
gt;
gt; Thankyou.
gt;
gt;
gt;
gt;Thankyou

quot;Stevedquot; wrote:

gt; Hello from Steved
gt;
gt; Please how does one go about highlighting every second row please using a
gt; light grey.
gt;
gt; from A3:C3, to A5:C5, to A7:C7, and so on I've got 3,450 rows to do.
gt;
gt; Thankyou.
gt;
gt;
gt;
gt;