VBA code isn't needed.

Select all the columns

Use formatting = Conditional formatting


condition 1

Formula is =mod(row(),2)=0
Pattern is yellow

condition 2
formula is = Mod(row(),2)=1
Pattern is gray

--
Regards,
Tom Ogilvy


lothario wrote in message
...
Hi,

I have a worksheet which has over 50,000 rows of data and 10 columns.
I would like to appy background color to all this data to make it easy
to read.

Here is what I need:

a. All the odd numbered rows in the range a5:j50004 should
have a gray background color.

b. All the even numbered rows in the range a5:j50004 should
have a yellow background color.

c. This color scheme should remain when existing rows are
deleted from this range.

d. This color scheme should remain when new rows are
inserted into this range.

Please show me the VBA code to do all of the above.
In what part of the spreadsheet should this code reside?


Thanks.
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/