Thanks a lot,
I tried this. but i am am getting only Red Colour. I need the colours to be based on Range.
IF(Condition1 = 'Between',
IF(column1<ULimit1 and column1>= LLimit1,$(ColourCode1),
is satisfied, it does not go to the else part. I am only getting red colour and not the green colour.
I want both to be present.