Sorting and Protection

[Joe]

Here is my dilemma. I created a worksheet where evry
other row is shaded for ease-of-use by users. The shaded
rows, as well as a few columns are protected so users can
only enter data into a few cells in each row.

My problem is that I want to sort the rows while keeping
the format of every-other-row shaded. Any idea how I can
do this? Should I have formatted the worsksheet
differently.

Any suggestions are appreciated

 

[Frank Kabel]

Hi
you can use conditional formating to do this. Have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for instructions how to do this

 

[Gord Dibben]

Joe

Use Conditional Formatting to shade the rows. The alternate shading will
remain in place through sorting.

Select rows down as far as you want the shading.

Format>Conditional Formatting>Formula Is: =MOD(ROW(),2)=1

Pick a color and OK your way out.

Gord Dibben Excel MVP