+ Reply to Thread
Results 1 to 5 of 5

Color Count in conditional formatting in pivot table

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    INDIA
    MS-Off Ver
    EXCEL 2010
    Posts
    53

    Color Count in conditional formatting in pivot table

    FRiends

    Please go through the attach file where I have mange to do the conditional formatting in pivot table. Result is I am getting color codes as required, now I want some formula which will count & sum based on color coding of conditional formatting.

    Thanks.

    Mangesh
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Color Count in conditional formatting in pivot table

    Mangesh, I've not looked at your file but if you used Conditional Formatting to format the cells then simply use the same logic "rules" in your formula to count & sum - you don't need to work off the format.

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    INDIA
    MS-Off Ver
    EXCEL 2010
    Posts
    53

    Re: Color Count in conditional formatting in pivot table

    Hi
    I have tried that (with some references on google) but to my knowledge it is not working since it has relative references.

    Thamks.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Color Count in conditional formatting in pivot table

    I'm afraid I don't really have a huge amount of time to spend on this but as a general pointer...

    Please Login or Register  to view this content.
    Last edited by DonkeyOte; 10-15-2010 at 06:55 AM. Reason: added $ just in case....

  5. #5
    Registered User
    Join Date
    08-16-2010
    Location
    INDIA
    MS-Off Ver
    EXCEL 2010
    Posts
    53

    Re: Color Count in conditional formatting in pivot table

    Millions of Thanks !!!!!!



    It works !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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