Hi,

I have a report need to change one field background color based on another field data, and data at the field self.
E.G.

Category Number

Apply 100
Orange 50

if category column shows Apply, then
when Number > 100, Number field backgroud color is Black
Number >50 and < 100, Number field background color change to Green.
When Number <50, Number field background color change to Red.

if Category column shows Orange, then
when number > 50, Number field background color is Black
Number <50 and >20, color is Green
Number <20 then Number field background color is Red

Would someone give me suggestions how to do that?
I searched online, only see change background color for one field and based on this field value.

I am much appreciated if someone can help me out.

Thanks a lot.