I have a pivot table, the row label is a vendor name the column label is a aging status and the value is a dollar amount, I also have a column in the report of priorities and I would like that if the priority column is "1" then on the pivot table that vendor should be colored yellow,
I believed it could be done in the conditional formatting but I don’t know how.
your help is greatly appreciated.