Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to highlight the cells in expression columns (Design, Vendor runoff & Launch) with yellow if the value of document is 'P', in a pivot table using visual cues.
Please assist.
It should be on the Expressions tab under Background Color or Text Color.. depending on what you want to color...
So, if any of the three expression have P, you would want to highlight the complete row? or are you looking to just highlight the cell with P in it?
just that cell....
Try this for background color expressions
For Design expression
If([Design] = 'P', LightRed())
For Vendor runoff expression
If([Vendor runoff] = 'P', LightRed())
For Launch expression
If([Launch] = 'P', LightRed())
I have tried these expressions.
My question is where in pivot table I should put these expressions ?
It should be on the Expressions tab under Background Color or Text Color.. depending on what you want to color...
Thanks Sunny....