Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why do I lose cell format in a pivot table?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why do I lose cell format in a pivot table?
No. You should have another column of values to signify the category with an actual entry - using
colors is generally not a valid data technique, though it is handy for reports. Then, you could apply conditional formatting based on that field's value. HTH, Bernie MS Excel MVP "Megglesface" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Pivot Table | Excel Discussion (Misc queries) | |||
Why would a pivot table lose its character? | Excel Worksheet Functions | |||
Piovt Table-Drill Down Numbers lose Currency Format | Excel Discussion (Misc queries) | |||
Why do I lose hundredths when summing elapsed times in a pivot tab | Excel Discussion (Misc queries) | |||
Pivot Tables lose some formatting when Updated | Excel Discussion (Misc queries) |