Hi:

I am trying to imput the following Conditional Formatting relating to costing:
2 columns -
Column A has a costing goal
Column B has the costing actual
I want the conditional formatting to reflect how close the costing actual
comes to the goal

Green- if cell B value is < or = column A
Yellow- if cell B value is greater than A but less than A+3%
Red- if cell B value is greater than A+3%

I have tried entering the appropriate conditions but it will only choose
Green or Red. Yellow won't work.

Can you help? Thanks!