I have a pivot table that currently sorts four columns using macro buttons that I click at
the top of the four columns.
I just highlighted various cells in Col A (yellow) and would now like to sort the table
based on the cells I highlighted (and also in alpha order) having these highlighted cells
show at the top of the sort.
I also would like to have the option of changing the font color of certain cells
in Col A (say to red) and then sort the pivot table based on Col A and have
the red cells show up at the top of the sort.
Is this easy to do?
For those who like to see things visually, here is a tiny snippet:
Bookmarks