Link to home
Create AccountLog in
Avatar of agwalsh
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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

What formatting do you want on the Row labels?
Avatar of agwalsh
agwalsh

ASKER

The person asked me about having the same formatting on the row labels as on the values - data bars?
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
You can hide the numbers if that makes the formatting look better.

User generated image
Avatar of agwalsh

ASKER

nah, she wanted to get the NAMES formatted..you have given me the answer :-) Good enough for me.