Conditional formatting with formula

[drluke]

I am calculating % movements between sets of numbers usingthis formula:
=IFERROR(IF(ABS((B1-C1)/C1)>5,””,(B1-C1)/C1),”-“)
I now need to add conditional formatting to the formula (orsomewhere) that will apply different formatting depending on which range ofcells and the result:

Turnover Range (B1:C8) - if movement between B & C is adecrease the % in D must be red. If it’san increase it must be green
COS Range (B12:C20) - if the movement is a decrease – green. Increase = red
Gross Profit Range (B22:C28) - decrease = red. Increase = green
Expenses Range (B32:C50) - decrease = green. Increase = red

Is this kind of formatting even possible in Excel?

 

[yky]

Re: Condditional formatting with formula

For turnover, select D1:D8, go to Conditional Formatting/New Rule/Using a formula to determine...., enter "=C1>B1", and choose a green color as the fill color.