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.
The link to excel workbook is >>https://1drv.ms/x/s!AlMkmnpeQjaSy2eP4cID5Gj0Z-rh
If anyone require any further info,then kindly let me know.
I have also posted this at forum http://www.excelforum.com/showthread.php?t=1151084&p=4453644&highlight=#post4453644
I haven't still recd reply.
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.
The link to excel workbook is >>https://1drv.ms/x/s!AlMkmnpeQjaSy2eP4cID5Gj0Z-rh
If anyone require any further info,then kindly let me know.
I have also posted this at forum http://www.excelforum.com/showthread.php?t=1151084&p=4453644&highlight=#post4453644
I haven't still recd reply.