Shade even rows in a sheet

[CB]

I am hoping there is an easy way to get excel to shade all even rows in a
work sheet that have data in them (as the range will vary from week to week).
I only need Columns A through X shaded.

Can anyone help?

Many thanks in advance.

 

[Chip Pearson]

You can use Condition Formatting to do this. See
http://www.cpearson.com/Excel/banding.htm for examples.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[CB]

Thanks Chip. I will check this out.

You can use Condition Formatting to do this. See
http://www.cpearson.com/Excel/banding.htm for examples.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)