Conditional Formating - Pivot Tables -VBA
Results 1 to 3 of 3

Thread: Conditional Formating - Pivot Tables -VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2013
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formating - Pivot Tables -VBA

    Hello I am trying to band the rows in a pivot table based on changes in row values in a specific column. Any ideas? I would like the bands to change from white to grey.

    Any help is appreciated.

    Thanks,

    -Jeff

  2. #2
    Board Regular
    Join Date
    Apr 2015
    Location
    Sydney
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formating - Pivot Tables -VBA

    Hey, tried looking at this video, I think it should work for your problem, if not sorry about wasting your time.

    Conditional formatting - highlight entire row based on a cell value

  3. #3
    New Member
    Join Date
    Sep 2013
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formating - Pivot Tables -VBA

    Excel - Shading entire row based on change of value - Stack Overflow

    Found a solution here. Now just need to figure out how to get it in VBA

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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