sort

B

BWR

Hello, how can i sort a huge list of lines in a worksheet without changing
the cell shading in the background? I have entered several lines of info and
staggered the shading in the cell lines (gray, then white, then gray, etc) to
make the worksheet easier to follow lines. Each time I sort the data in the
worksheet it takes the cell shading with it. I want to leave the cell
shading in the background and sort only the data.
 
M

Max

Tinkered with it in this manner, seems to work ok:
Make a copy of your original sheet, with the desired formatting*
Sort the original. Go back to the copy, select the range/entire sheet, copy
the formatting (click the Format Painter icon, the brush). Then go back to
the original, "paint" to restore the formatting.
*Formatting is assumed non CF
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
 
B

Bernie Deitrick

Format all the cells white, then use Conditional formatting with the
"Formula is" condition with the formula

=MOD(ROW(),2)=0

and set the color to gray.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top