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.

Please post your sheet on the forum so that all members can access it easily . This will give you more answers. Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post