View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max2073 Max2073 is offline
external usenet poster
 
Posts: 40
Default 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.