Related:
- How To Sort/Group All Highlighted
- How to sort bookmarks in chrome - Guide
- Spotify sort by genre - Guide
- How to sort instagram comments by most liked - Instagram Forum
- How do you highlight a message on whatsapp ✓ - WhatsApp Forum
- How to highlight overdue dates in excel ✓ - Excel Forum
1 response
How is the highlighting being done? Manually or via a macro?
If a macro is doing it then:
Add a column and place a value that corresponds to the highlight. So, for all rows in Yellow, put the word yellow,for Red , put red. The foreground color of the cell should be the same color as the background so you wont see the word. Then group by this new column. All the colors will be sorted and grouped together.
Same could be done manually of, course.
If a macro is doing it then:
Add a column and place a value that corresponds to the highlight. So, for all rows in Yellow, put the word yellow,for Red , put red. The foreground color of the cell should be the same color as the background so you wont see the word. Then group by this new column. All the colors will be sorted and grouped together.
Same could be done manually of, course.