Thread: [Solved] CF in Pivot table by code
View Single Post
 
Old 08-13-2016, 08:36 PM
paradise paradise is offline Windows 8 Office 2013
Novice
  
Join Date: Aug 2016
Posts: 1
paradise is on a distinguished road
Default CF in Pivot table by code
Hi,

I am looking for a code/macro for conditional formatting in Pivot table.The workbook has 3 sheets .The PT-1 worksheet is Pivot table and I want to highlight the row as stated in dummy data.Sample highlighted row is given for the kind reference as my expected result.The condition that was highlighted on the condition that ,if K column of SO sheet contains "Not Approved" then in Pivot Table it will highlight the row which has been done manually currently.



If anyone require any further info,then kindly let me know.
Last edited by Pecoflyer; 08-13-2016 at 11:35 PM. Reason: Removed external link
Reply With Quote