I am trying to color code a column C1 in my report. the column contains Sales amount in Dollars. Some are negative and some values are postive.
now the conditions i need to define are based on a percentage calculation in another column C2 also present in the report. if the percentage value in C2 is greater than 10 than C1 should be green. if C2 is less than 10 than red. and if equal to 10 than yellow.
How can i accomplish this.