Related:
- How To Sort/Group All Highlighted
- How to sort bookmarks in chrome - Guide
- Spotify sort by genre - Guide
- How to highlight overdue dates in excel ✓ - Excel Forum
- Water sort puzzle free download - Download - Puzzle
- The formula contained in the yellow highlighted cell (i39) is ✓ - 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.
