Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have different TAT values depending on the values want to set the row color,
as if
If(TAT>20, color should be blue)
If(TAT>35, color should be orange)
If(TAT>50, color should be red)
have tried by visual cues but can only do it for one minimum and one maximum value for corresponding column
I am trying this in Pivot table chart
Please help me out into this
Regards,
Prashant A.
Hi Prashant,
In the expressions tab expand (click the +) the expression on the left and select background color. In the expression box on the right, put in =IF(TAT>20,Blue(),IF(TAT>35,Orange(),IF(TAT>50,Red(),White())))
The Orange() might need to be Amber() or something - can't remember! Check the F1 help for the preset colours, otherwise use RGB(r,g,b)
Hope this helps,
Jason
Hi,
Hope the attached file helps you in understanding the color expressions.
Regards,
Jagan.
Oops - got the numbers back to front! Should have been:
=IF(TAT>50,Red(),IF(TAT>35,Orange(),IF(TAT>25,Blue(),White)))
Jason
Prashant,
You can try this.
If(TAT>20, RGB (0,48,255))
If(TAT>35, RGB (255,162,0))
If(TAT>50, RGB (255,0,0))
Regards,
Nandha
Prashant,
You can try this.
if(TAT>20,red(),(if(TAT>35,Blue(),white()))
Regards,
HarshVardhan