Sorting Cells with Conditional Formats

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

Is it possible to sort a spreadsheet containing conditional formats without
destroying the formats?

DOUG ECKERT
27 Apr 10
 
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
 
Back
Top