Sorting in excel without changing colors [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I have a simple spreadsheet in which every other row has a background color and the others have none. When I sort the rows I want the spreadsheet to keep the background colors in place and just sort the text.

Is this possible? If so, how do I do it?

I have office 2000.

Thanks, TDKIII

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi

I hope the procedure given in the site https://www.contextures.com/xlCondFormat03.html
for "Shade Alternating Rows" will solve your problem