VBA – Sort pivot table by colour

Hi,

I made Pivot table with four columns. First columun is ”ser.num”, Second, third and fourth column are months ( January, February and March). Values in First column are numbers and in others are currency. I made in conditional formating if values for each of three months are negative, than fill red  cell in first column ( For that serial num). How to sort First column to show ser. numbers filled red first, couse the list is very long, over two thousand ser. numberes. 

Thanks

By: DS

Leave a Reply

Your email address will not be published. Required fields are marked *