Conditional Formatting Pivot Tables
I don't seem to be able to select data elements for comparison in Pivot Tables.
I've 3 fields for the rows and 9 elements for my values. I don't have any columns specified. When selecting highlight, the value is locked so that only a number can be entered. I can't select an element from my data to use for comparison.
Is conditionally formatting with Pivot Tables not possible? I was looking at using Pivot Table for the total and subtotal functionality, but still want to conditionally format my data.