Shading rows

  • Thread starter Thread starter Larry Weaver
  • Start date Start date
L

Larry Weaver

Hello -

I am a teacher in an alternative school where we must keep
up with the contact hours of each student. I have been
doing this with Excel for 2 years but there is one thing
that really bugs me. I shade every other row light gray
to make the easier to follow a given student across an
entire month. This works fine until I have to add a new
student (I keep them in alpha order). I can't copy, cut
and paste because that screws the shadings up so I have to
insert a row, etc. etc...

Bottom line - can I lock the shadings of a row so I can
copy and paster data only?

Thank you
 
Larry

Select all cells. Go to Format/Conditional Formatting. Set it to 'Formula
is' and input:
=MOD(ROW()/2,1)=0

Andy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alternate row shading on filtered data 2
alternate row shading kept with autofilter 3
How do I maintain alternate row shading after inserting a new row 4
Formatting rows 10
Row Shading 1
show fill color of a shaded row 3
How do I alternate shading of rows, Excel 2007, no new tabs. 1
Unwanted shading of entire spreadsheet 2

Back
Top