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"
wrote in message
...
Is it possible to sort a spreadsheet containing conditional formats without
destroying the formats?
DOUG ECKERT
27 Apr 10