lundi 20 avril 2015

How to extract cells of a particular colour in pivot table?

I have applied conditional formatting to one column of pivot table in excel which automatically colours the cells greater then a particular value by red colour each time. However, I also want to extract those red cells every time separately to a specific area in the same sheet.

Can someone please help here? Can it be done using macros or a 'if' condition would also help here?

Aucun commentaire:

Enregistrer un commentaire