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.