i have created a pivot table to pull data through from a worksheet.
In the worksheet I have some cells with blue text and some with red text to
signify two catagories.
When the information is displayed in the pivot table all the text is black.
Is there a way to make sure the pivot table data corresponds to the colours
in the worksheet?

Thanks