Need to display data in a text object with background color changing according to given set of conditions

[#1]

Hi ,

I need to display a data in Text object based on the value of the background color of the text object should change and in the text object I need to  display the sum of Sales(Actual) for a given product in the text object with appropriate background color

If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is less than 60% the background should be in Red color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is greater than 85% the background should be in Green color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is between than 60% & 85 % the background should be in Yellow color.

I have attached the Sample Data for the same.

Any help in this regard is appreciated

Thanks in Advance

[nizamsha]

PFA

[tresesco]

May be like attached sample

[mdmukramali · Accepted solution]

Dear,

Kindly find the attachment.

Thanks,

Mukram.

[#5]

Thanks Nizam,tresesco,Mukram for your timely help.

All the three worked..:)