Forum Discussion

AnandRanga's avatar
AnandRanga
Icon for Helper III rankHelper III
9 years ago

conditional formatting in charts or tables ?

I want to show background color of my values in tables, like if values are between 20-60  : Red background else 61-90 : Yellow background.

I have tried conditional formatting , but i am unable to use <,> symbols in that . Isn;t it possible to format values using greater than and lower than symbols.

 

Thanks

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi AnandRanga


    When using the Conditional formatting you can change it to Absolute values. 

     

    When you do this you can then set what you want that Absolute range to be, so for the lowest it would be 20, then 60 and then 90 and put your colours against those Absolute values. That should get it working for you.