Change the color of cells in the pivot table which are referred by cells
in other sheets using GetPivotData.

Does anyone know how to do this? Thanks a million for your generous
help!


--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
View this thread: http://www.excelforum.com/showthread...hreadid=522384