Skip to main content

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

Comments

5 comments

  • Kobbi Gal

    Note: 

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

    0
  • 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
  • Nestor Valenzuela

    Hi There,

     

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

     

    Best regards,

    1
  • 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.

    2
  • 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

Please sign in to leave a comment.