agwalsh
asked on
Can I conditionally format ROW entries in a pivot table - not just the values?
I was recently asked if it was possible to apply conditional formatting to the ROW entries in a pivot table not just the values. In the attached pivot table - I've applied conditional formatting to the Sum of Units in Stock - but is there any way to extend that to the entries under Row Labels - I wasn't aware of any but I am open to correction. Conditional formatting row entries.xlsx. Thank you
What formatting do you want on the Row labels?
ASKER
The person asked me about having the same formatting on the row labels as on the values - data bars?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
You can hide the numbers if that makes the formatting look better.
ASKER
nah, she wanted to get the NAMES formatted..you have given me the answer :-) Good enough for me.