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

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" wrote:

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,
Even though you did think you understood my question, you understood it well
enough. Your answer was very helpful,

Thank you.

Lawrence

"Mike H" wrote:

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" wrote:

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

I withdraw the question. I found the solution.

"Lawrence Miller" wrote:

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

Hi,

And what solution did you find?

Thanks,
Shane Devenshire

"Lawrence Miller" wrote:

I withdraw the question. I found the solution.

"Lawrence Miller" wrote:

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

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

"Shane Devenshire" wrote:

Hi,

And what solution did you find?

Thanks,
Shane Devenshire

"Lawrence Miller" wrote:

I withdraw the question. I found the solution.

"Lawrence Miller" wrote:

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