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.

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
---
"BWR" wrote:
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.

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


"BWR" wrote in message
...
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.