Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

Β View Only
Back to discussions
Expand all | Collapse all

Highlight Cell Color in Report Table

  • 1.  Highlight Cell Color in Report Table

    Posted 02/06/23 04:34 PM
    I am looking to highlight cells in a table based on the value. Example: -5% to 5% is green, 5% to 10% or -5% to -10% is yellow, and >10% or <-10% is red. Does anyone know a way to accomplish this? 


    I found a highlight function for columns in a report table where you can enter and If statement to show a color.  I am not sure if this option would be able to do it. I tried it but I can't get it to color the cells correctly.

    ------------------------------
    KristineKleinTerex CorporationSr IT Operations Specialist
    ------------------------------

    #TBMStudio


  • 2.  RE: Highlight Cell Color in Report Table

    Posted 02/06/23 04:49 PM

    Hi @Kristine Klein - have you run across this post yet?​




  • 3.  RE: Highlight Cell Color in Report Table

    Posted 02/06/23 04:51 PM
    Thanks. I didn't see that.

    ------------------------------
    KristineKleinTerex CorporationSr IT Operations Specialist
    ------------------------------

    Original Message


  • 4.  RE: Highlight Cell Color in Report Table

    Posted 02/06/23 05:15 PM

    My teammate, Erin, did this recently where a client wanted to see red or green font, too, so sharing as well...


    This is what the Edit Column window looks like... 


    And the formula so you can copy/paste...   =Currency({$_},"#,##0",posColor="green")

    And this is the result...


    Credit: @Erin Lycke ​


    Original Message


  • 5.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 11:07 AM
    Thanks. I will add that into my report. Just curious. Is there a way to  color the background of the cell?

    ------------------------------
    KristineKleinTerex CorporationSr IT Operations Specialist
    ------------------------------

    Original Message


  • 6.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 12:01 PM
    Are you talking about something like this or conditional formatting?


    Original Message


  • 7.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 12:04 PM
    Conditional formatting


    ------------------------------
    KristineKleinTerex CorporationSr IT Operations Specialist
    ------------------------------

    Original Message


  • 8.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 12:18 PM
    @Kristine Klein, I believe you can use this. You have to highlight the column which you wish to do the conditional highlighting. In the formula window, you can basically put any formula to accomplish your logic. You can also use the HTML color code for specific shades of color.

    ​

    ------------------------------
    Tony Wong
    ExxonMobil TBM Analyst
    ------------------------------

    Original Message


  • 9.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 12:20 PM
    I was playing with that yesterday, but couldn't get it to work. I think I was doing the formula wrong. I will give this a try again. I do love all the information from this posting. I guarantee that I will be using both options for some of my reports.  Thank you all

    ------------------------------
    KristineKleinTerex CorporationSr IT Operations Specialist
    ------------------------------

    Original Message


  • 10.  RE: Highlight Cell Color in Report Table

    Posted 02/07/23 12:25 PM
    It takes a village @Kristine Klein! 🀩  Thanks for that, @Tony Wong​!  Learn something new every day! πŸ™Œβ€‹
    Original Message


  • 11.  RE: Highlight Cell Color in Report Table

    Posted 02/08/23 03:02 AM
    Indeed. @Tony Wong has provided several insights over time that border the paranormal! πŸŽƒπŸŽƒπŸŽƒβ€‹


  • 12.  RE: Highlight Cell Color in Report Table

    Posted 07/02/24 05:04 PM

    Wanted to add this to the thread. I was looking to highlight "greater than 10%" and "less than -10%." After some trial and error, this worked for me.




Related Content