Changing Color Of Specific Cells In A Pivot Based On Textual Condition

Comments

5 comments

  • Avatar
    Kobbi Gal

    Note: 

    Please remove the dashed line separator ("----------------------------------------------------") from the script.

    0
    Comment actions Permalink
  • Avatar
    Sanjoy Ghosh

    Hi Omer,

    I found this useful but want to color the entire row based on a textual condition. Eg. If condition_value = 'Africa', the entire row should be green else red . Is it possible ?

    0
    Comment actions Permalink
  • Avatar
    Nestor Valenzuela

    Hi There,

     

    How can I do this but with two condition value or more?

     

    Best regards,

    0
    Comment actions Permalink
  • Avatar
    Robert Vaughan

    Hi All,

    This is a great script which works well for 1 column,  but what If I had multiple columns which I want to Colour?  say column 8 is red if cell value = 'Overdue' and column 9 red if cell value < 0, and column 10 red if cell value > 3.

     

    thanks,
    Rob.

    1
    Comment actions Permalink
  • Avatar
    Sam Nicholls

    This is great!  Can you advise the code change when using the 'Text: Containing' dashboard filter?  We have a dashboard that a user may perform a search using the 'Text: Containing' filter option..

    Our issue is we dont know what the user will type in(search for), but whatever they do search for, that should be highlighted in the pivot.  

    0
    Comment actions Permalink

Please sign in to leave a comment.