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!