Sorting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
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
 
Back
Top