Hi all,
Workbook: Book2.xlsx
When I double click on a pivot table, I will get detail for all my data on a new sheet (usually named Sheet1).
Is there a way to conditional format the detail data every time I double click the pivot table?
For example, I would like the value in the ID column to always highlight red (for each new sheet) if it is equal to 1.
Thanks!
Bookmarks