Change background color based on two field data at SQL Server 2008 R2
I have a report need to change one field background color based on another field data, and data at the field self.
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.