Color Coding

Hi All,

I have a report contains ,some sales fields. In that I have a parameter called highlighting the values are no color, segment wise, metric wise.

Now i need to apply color codes based on value selected in highlighting parameter.

1) If user selects segment wise in highlighting parameter then i need to highlight entire detail section except sales 1, sales 2 fields and no color selected no coloring required.

2) If user selects no color then no highlighting is required.

3) If user selects metric wise and if sales 1 > sales 2 then i need to highlight only sales 2 field and no color selected no coloring required for that field.

And if no value selected in highlighting parameter defaultly no color should be applied

Please suggest