Howdy

I have a little problem with a pivot table. I have 3 levels of rows (Contractor, Type of Contract and Description of Contract), I want to be able to highlight the Contractor based on the Type of Contract.

Simplifying: I need the table to highlight all Contractors that have a type of contract "Subcontractor". Is this possible?

pivot screenshot.PNG