IBM Apptio

 View Only

 Highlighting/Text Color Changing Based on Value

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Abra McCollum's profile image
Abra McCollum posted Mon June 07, 2021 12:40 PM
Hello! I am trying to either highlight a value in a report column with a particular color or change the text color based on that value and I am running into a few issues. 

1. Is there a way to highlight a cell based on multiple values? For example, if the value is < .75 OR > 1.25 then it would be red. 
2. Is there a way to include multiple colors? For example, is there a way I could use a range for the colors? 
             < 75% red

              75% - 90% yellow
              90% - 110% green
              110% - 125% yellow
              > 125% red

I have played with the Highlight feature on the data tab and can work out one color, but haven't been successful with a formula that will show more than one color.

I have also used the Advanced Format for the data and again been able to successfully change the color based on one value using this formula:
                     =IF({$_}>1.15,NumberFormat({$_},"#,###.00%",posColor="#FF000"),NumberFormat({$_},"#,###.00%"))


If I can figure out some of this, that would be great. But, then I run into the issue of both not working when I add in my time columns (in this case, months). So, this is another large issue I am trying to tackle. 

Thanks for any help/advice!
#CostingStandard(CT-Foundation)
Chris Davidson's profile image
Chris Davidson posted Wed July 14, 2021 03:42 PM  Best Answer
=If(Cost > 500000, "green", If(Cost > 100000, "yellow", "red"))




#CostingStandard(CT-Foundation)
Jenny Franklin's profile image
Jenny Franklin posted Wed June 09, 2021 08:50 AM
@Aaron Rhoney didn't you do something like this on one of the reports ​you built?
#CostingStandard(CT-Foundation)
Debbie Hagen's profile image
Debbie Hagen posted Tue June 29, 2021 03:00 PM
@Chris Davidson  I feel like you covered something like this in one of your sessions.  Do you have a suggestion for @Abra McCollum
​​
#CostingStandard(CT-Foundation)
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Wed June 30, 2021 08:01 AM
I have used the Icon() formula. In your case maybe something like:
=Icon("3colorcircles",(variable<1.1 AND variable>.9),(variable<0.9 AND variable>0.75) OR (variable<1.25 AND variable>=1.1),variable<=0.75 OR variable>=1.25)

Not identical, but the results look similar to what you want, @Abra McCollum:



(You may have to tweak the conditions and add an "=" here and there so that there are no holes).​
#CostingStandard(CT-Foundation)
Debbie Hagen's profile image
Debbie Hagen posted Wed July 14, 2021 07:04 PM
Thanks Chris and Guillermo,
I wish it would let me mark 2 things as best answer.  Those are both good solutions!​
#CostingStandard(CT-Foundation)

Related Content