Basic Sort ?

Corticus · May 8th, 2002, 11:30 AM

Is there anyway to sort a table without sorting the cell formats?

I have a table where each line is an alternating shade so its easier to read, but when I sort, it sorts the colors too, so they're no longer alternating.

-Corticus

lenze · May 8th, 2002, 11:52 AM

Use Conditional formatting based on the row number to shade your rows.

These formulas can be used with conditional formatting to shade alternate rows.

=MOD(ROW()-Rw,N*2)+1<=N This is for odd banding

=MOD(ROW()-Rw,N*2)+1>=N This is for even banding

Rw = Starting Row Number

N = Number of rows in each band

HTH

Corticus · May 8th, 2002, 12:30 PM

Thats what I needed, Thanks a bunch for the help!

Corticus

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 11:30 AM	#1
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	Is there anyway to sort a table without sorting the cell formats? I have a table where each line is an alternating shade so its easier to read, but when I sort, it sorts the colors too, so they're no longer alternating. -Corticus

May 8th, 2002, 11:52 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Use Conditional formatting based on the row number to shade your rows. These formulas can be used with conditional formatting to shade alternate rows. =MOD(ROW()-Rw,N2)+1<=N This is for odd banding =MOD(ROW()-Rw,N2)+1>=N This is for even banding Rw = Starting Row Number N = Number of rows in each band HTH

May 8th, 2002, 12:30 PM	#3
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	Thats what I needed, Thanks a bunch for the help! Corticus