Sorting Cells with Conditional Formatting

  • Thread starter Thread starter Edie
  • Start date Start date
E

Edie

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" <
(e-mail address removed)>
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing cell colors 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Hold conditional formatting when sorting filtered data 1
Excel Highlighting duplicates 0
sorting spreadsheet with conditional formatting 1
Excel Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional formatting does not follow value when list is sorted 3

Back
Top