Pass formating to pivot table

[swaink]

Hi All

I wonder if I may impose on upon you once again, I have spent considerable time creating a workbook to meet the needs of the users. In particular they required color codes for each row where a certain critera was met.

I have achieved this succesfully however they now create a pivot table from that spreadsheet and can no longer see the color coding.

My question is, is it possible to transfer formating from a spreadsheet into a pivot table or do I need to start over again

All advice appreciated

Thank you

 

[Greg Truby]

Formatting from source data cells will not copy to a pivot table.

However, you can apply conditional formatting to cells inside a pivot, so rather than format by hand, you might be able to highlight the cells of interest using CF.

 

[schielrn]

Is it manual coloring on the other worksheet that the pivot table is pulling from or is it colored by conditional formatting?

 

[swaink]

Hi Guys thanks for the quick responce

I have values in the last two columns of the sheet and I have used conditional formating on the spreadsheet to highlight the rows where appropriate

Kev

 

[Greg Truby]

Then my first inclination would be to apply the same CF to the PT. If you have to do this frequently then maybe think about using some VBA to automate the application of the CF (can probably automate applying CF to both source data & the PT).