help with sorting

B

bc

I have an excel spreasheet that I am trying to sort. Some rows are
highlighted, some are not. When I select the rows I want to sort, my
highlights end up in some of the rows that were not previously highlighted
and some of the non-highlighted rows end up with highlights. It is not
consistent. It ends up with a portion of a row highlighted and all
scrambled. Anyone know what i need to do? Please help!
 
G

Gord Dibben

How are the rows highlighted?

Manually or by Conditional Formatting?

Is there any pattern to the highlighting?


Gord Dibben MS Excel MVP
 

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

more rows highlight than I want 1
Sorting rows by colors 1
Stop Autofill/Highlight of cells 1
Is there a way to filter by format? 2
Sorting data by highlighting? 1
Sorting by Color in Excel 2003 5
Excel Sorting 1
Remoew row highlighting when workbook is closed 5

Top