conditional formatting in charts or tables ?

[AnandRanga]

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

[GilbertQ]

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.