Gradient conditional formatting in pivot tables

Comments

6 comments

  • Avatar
    Brian Wilson

    🔥🔥🔥🔥🔥

    This is hot fire! Nice Tom.

    1
    Comment actions Permalink
  • Avatar
    Katie Garrison

    This is super useful, thanks Tom!

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    NICE! 

    Thanks (: 

    0
    Comment actions Permalink
  • Avatar
    Gabi Susser

    Tom this is great. Thanks!

    Is it possible that the colors will be relative for each columns by itself and not compared to other columns?

    I'll try to explain through your example here:

    i would like that each column of docs will show the gradient conditional format as a whole and not compared to other columns of docs.

    for example the number 7 in the column of docs under the active negotiation category will be in very dark blue because its the highest number in the column. in your example this column is compared to all other columns of docs under all the categories and therefore in your screenshot the number 7 gets a pale color (because of significantly higher number in other columns of docs).

    Gabi

     

    0
    Comment actions Permalink
  • Avatar
    Tom Strader

    Gabi Susser because this script just runs on top of data bars and that's the behavior of data bars, there isn't a simple way to change it.

    You could likely write a different plugin to get that effect, but would probably be limited to gradients for what is on the current page (and not include the fact that higher/lower numbers may exist on other pages).

    0
    Comment actions Permalink
  • Avatar
    Gabi Susser

    OK. Thanks Tom.

    Tom Strader

    0
    Comment actions Permalink

Please sign in to leave a comment.