Shade even rows in a sheet
 

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.

Shade even rows in a sheet
 

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)


On Tue, 9 Dec 2008 11:58:01 -0800, CB
wrote:

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.

Shade even rows in a sheet
 

Thanks Chip. I will check this out.

"Chip Pearson" wrote:

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)


On Tue, 9 Dec 2008 11:58:01 -0800, CB
wrote:

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.