Thanks. Please let me if it is possible to check for a range of values and give different colors. Something like 20-30 and give red color, 30-40 yellow color etc..
Sure, try like this:
If(FieldName > 20 and FieldName <= 30, Red(),
If(FieldName > 30 and FieldName <= 40, Yellow(),
If(FieldName > 40, Green())))