Highlighting doesn't always sort -- Borders never do

[Mike Welch]

Hi all - I'm trying to sort an Excel 2003 workbook where some of the cells are highlighted and a few have single cell borders. The sorts are simple alpha or numeric ASC or DESC - nothing fancy.

Sometimes the highlighted cells move with the data during the sort but othertimes the data move and the highlight stays with the cell (not the data). The cell borders always remain with the cell and don't sort with the data. I want the highlights and borders to always and only sort with its associated data.

Any thoughts?

Mike Excel 2003 / Win XP Pro

 

[Lewiy]

Borders will never sort. I'm not sure how you'd get around that without a macro, but it hardly seems worth it (of course you may have a very good reason!!)

Cell colours should ALWAYS sort with the data. Do you have conditional formatting set on any of these cells, that might account for cell colours changing.

 

[Mike Welch]

I'll have to look into whether that region of the sheet has color-specific Condtitional Formatting ... it might. I'll ceertainly keep it in mind next time I see it occur - thanks!