I am trying to sort cells that contain conditional formatting and the format
does not stay with the cells. It appears to be keeping the formatting of the
item that was in that cell previously.

try to navigate a little bit on the Mr Chip Pearson page


http://www.cpearson.com/excel/MainPage.aspx


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Edie" escreveu:

I am trying to sort cells that contain conditional formatting and the format
does not stay with the cells. It appears to be keeping the formatting of the
item that was in that cell previously.

Conditional formats and cell borders do not sort (move) with the data.
Some conditional formats depend on data being located in particular cells.
So even If you were able to move the CF with the sorted data, some CF's could be incorrect.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - "Special Sort" has a conditional formatting option)



You may want to try out the commercial
"Edie" <

wrote in message
I am trying to sort cells that contain conditional formatting and the format
does not stay with the cells. It appears to be keeping the formatting of the
item that was in that cell previously.