Shading multiple rows or, alternately, multiple columns only

[Lawrence Miller]

How does one shade multiple rows or, alternately, multiple columns only.

This is a great group. I have been helped many times here. I thank you in
advance for any help you might give me.

Lawrence Miller

 

[Mike H]

Hi,

I don't really understand the problem. To shade multiple rows/columns select
them and then shade them with a colour.

Do you mean odd/even alternate rows? In which case that's easiest done with
conditional formatting using formula is

For odd rows
=MOD(ROW(),2)=1

For odd columns
=MOD(Column(),2)=1

Change the 1 to a 0 for even rows/columns

Mike

 

[Lawrence Miller]

I withdraw the question. I found the solution.

 

[Shane Devenshire]

Hi,

And what solution did you find?

Thanks,
Shane Devenshire

 

[Lawrence Miller]

Mike,
Even though you did think you understood my question, you understood it well
enough. Your answer was very helpful,

Thank you.

Lawrence

 

[Lawrence Miller]

Hello Shane,

Unknown to me at the time, the answer above, from Mike H., had already come
before I managed to withdraw the question . His answer was quite helpful in
that it expanded on an old answer to a similar question I found on my
computer from some time ago. Too bad I didn't first check my computer for a
possible answer. I had it in D: > UTILITIES & DOCUMENTIONS > MS Excel >
Shading cells in Excel.doc from a long time ago.. However, it was worth it
to get the added clarification that Mike H supplied.

You guys are a tremendous resource and I really appreciate you all.

Lawrence