Prev: MATCH
Next: Excel 2007 "=hyperlink" function & Save As PDF
From: DOUG on 27 Apr 2010 09:43
Is it possible to sort a spreadsheet containing conditional formats without
destroying the formats?

DOUG ECKERT
27 Apr 10
From: Bob I on 27 Apr 2010 09:53
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

From: Jim Cone on 27 Apr 2010 10:24

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" <DOUG(a)discussions.microsoft.com>
wrote in message
news:863FE687-5BF9-4CDF-99D5-E4B1D9A38200(a)microsoft.com...
Is it possible to sort a spreadsheet containing conditional formats without
destroying the formats?
DOUG ECKERT
27 Apr 10

 | 
Pages: 1
Prev: MATCH
Next: Excel 2007 "=hyperlink" function & Save As PDF