+ Reply to Thread
Results 1 to 3 of 3

CF in Pivot table by code

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    CF in Pivot table by code

    Hi,

    I am looking for a code 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.
    Last edited by paradise2sr; 08-10-2016 at 07:33 AM.

  2. #2
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Re: CF in Pivot table by code

    I am still eagerly waiting for the reply.

  3. #3
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Re: CF in Pivot table by code

    I am still waiting .............

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-14-2016, 03:51 PM
  2. [SOLVED] VBA Code pivot table filters - Can i add another to my code
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2015, 09:23 AM
  3. [SOLVED] VBA code to turn data into pivot table and then into pivot chart
    By Faintkitara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2015, 09:05 PM
  4. Need a VB Code for Pivot Table instead of using custom format code
    By Linus100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2014, 01:13 PM
  5. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  6. Pivot table code help
    By Eison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2006, 08:55 PM
  7. VBA Code for a pivot table to open database and to reference table current page
    By Pete Straman Straman via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1