Cell borders and CF conditions do not move with sorted cell values.
Forcing the CF conditions and borders to move with the cell values can be done using VBA code.
However, if the CF conditions depend on the row number (for instance) then the resultant CF colors may not be what you
want.
--
Jim Cone
Portland, Oregon USA
(Info on my Special Sort add-in... http://www.contextures.com/excel-sort-addin.html )
"DOUG" <[email protected]>
wrote in message
Is it possible to sort a spreadsheet containing conditional formats without
destroying the formats?
DOUG ECKERT
27 Apr 10
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.
