Accessing Pivot Table's Data
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Accessing Pivot Table's Data
 

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.

--
Regards,
Tom Ogilvy

"spjoseph0511" wrote in message
...

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, based
on the values of other fields returned by the query. How do I
accomplish this?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/