+ Reply to Thread
Results 1 to 1 of 1

Conditonal Formatting for Pivot Table

  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    Dominican Republic
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditonal Formatting for Pivot Table

    Hello,

    I want to format Pivot Table Rows based on the value of a cell.

    this is my pivot table https://docs.google.com/open?id=0B3c...XE3VkhVR0pVQTA

    As you can see from the picture (Sorry for the Spanish, i'm Dominican). Every Row is formatted according to the value of the cells
    in the las column. if the cell is "AGOTADO" the pivot table row will be grey and if the cell is "VENCIDO" the pivot table row will be red.

    My problem is that i want to format the rows starting from the third column up until the last column so that it looks like this:

    https://docs.google.com/open?id=0B3c...0lvbHRCYUF2R2M

    this is the code that i have so far(which i found on the internet) but i don't know how to change it so that it does what i want:


    Please Login or Register  to view this content.


    Moderator Edit:

    Welcome to the forum, MAX8899.

    Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.
    Attached Images Attached Images
    Last edited by Cutter; 10-15-2012 at 05:22 PM. Reason: Added code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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