Sorting rows

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.
--
Mario

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
"Mario" <mario.rodriguez2@lackland.af.mil> wrote in message
news:2ECB703E-852C-4A18-934B-99992A1E97BF@microsoft.com...
>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.
> --
> Mario

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


"Mario" wrote:

> 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.
> --
> Mario

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
"Die_Another_Day" <charles_suzyq@mchsi.com> wrote in message
news:uqP7YPqpGHA.2360@TK2MSFTNGP05.phx.gbl...
> 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
> "Mario" <mario.rodriguez2@lackland.af.mil> wrote in message
> news:2ECB703E-852C-4A18-934B-99992A1E97BF@microsoft.com...
>>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.
>> --
>> Mario
>
>