Shading multiple rows or, alternately, multiple columns only

  • Thread starter Thread starter Lawrence Miller
  • Start date Start date
L

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

Thank you.

Lawrence
 
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
 
Back
Top