Sorting rows

[Guest]

I have a spreadsheet that has alternating gray/white row colors. When I sort
the spreadsheet by rows, the colors sort as well. Is there a way too sort
without the colors in the rows sorting as well. I creates problems with the
format of the spreadsheet.

 

[Die_Another_Day]

Use Conditional formatting to alternate row coloring like this:
Highlight the used rows in your spreadsheet
Click the "Cell Value Is" Drop-Down and select formula is and enter
=A1=MOD(ROW(),2)
Change out "A1" for the top left cell in your range

HTH

Die_Another_Day

 

[Guest]

I'd suggest using Conditional Formatting to shade your rows.

Select your range to shade
From the Format Menu, select "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(ROW(),2)=0
Select your format (grey background)
Click OK

Now your shading is based on the row number and not tied to specific cells.

HTH,
Elkar

 

[Die_Another_Day]

Whoops forgot the last step. After you enter the formula in, choose
"Format..." then select the Patterns tab and choose your color, then click
"Ok"

HTH

Die_Another_Day