How to prevent underlying shade row color from moving in Sort

[Pitch]

I'm pretty new to Excel, I've got the 2004 version.

I have set up a data base of rows of data.

I have every selected every other line and shaded those lines light
grey (so it looks like a classic ledger paper, for easier legibility).

However, when I sort the data, the shade color moves with each row of
data.

Is there a way to get the underlying shade to remain where it is, and
not move with the data?

thanks

 

[Bernard Rey]

I have set up a data base of rows of data.

I have every selected every other line and shaded those lines light
grey (so it looks like a classic ledger paper, for easier legibility).

However, when I sort the data, the shade color moves with each row of
data.

Is there a way to get the underlying shade to remain where it is, and
not move with the data?

One way could it can be done is using the "Conditional Formatting" option
(from the "Format" menu):

Select cell A2. In the "Conditional Formatting" windows, select the "Formula
Is" line from the drop down menu on the left. In cell blank cell that's next
to it paste the formula:
=MOD(ROW(A2),2)=0

and then set up the light grey background color. Click the "OK" button.

Now your cell A2 should be grey. If it isn't, re-open the "Conditional
Formatting" pane and make sure some extra quotes haven't been added to the
above formula (this happens sometimes).

Copy cell A2 and, using a "Paste Special" > "Formats", spread that format as
much as needed. Then you can sort your data, the color will look like it has
not moved with the data.

Note this doesn't work with the autofilter, in which case the lines are just
hidden.

 

[R.Pelkie]

-----Original Message-----

Click on diamond, upper left corner.
This will highlite the whole page.
Click on
Format - Conditional Format
Choose "Formula Is" and type:

=MOD(ROW(),2)=0

Click Format and Pattern and select color of lines.