Sorting Cells with Conditional Formats
 

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

DOUG ECKERT
27 Apr 10

Sorting Cells with Conditional Formats
 

Yes, as long as the Sort doesn't change the value of the "condition".

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

DOUG ECKERT
27 Apr 10

Sorting Cells with Conditional Formats
 

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