Accessing Pivot Table's Data

[spjoseph0511]

I have a pivot table that is linked to data returned by MS Query.
I'd like to highlight cells in the data body of the pivot table, base
on the values of other fields returned by the query. How do
accomplish this

 

[Tom Ogilvy]

Select your cells and apply conditional formatting (format, conditional
formatting)

This would need to be done after each change in the pivot table I believe.