Pivot Table - Format Columns based on Criteria
 

Hi,

At the beginning of the week I run a macro that automatically creates a
number of pivot tables. I would like to know if it is possible to bold
columns and data that meet a criteria within the pivot table.

eg bold both the column and data that have a column heading of "Orange",
"Apple" and "Pineapple".

If it is possible can I also do this by macro.