Try it in this manner ..

Assume data in cols A and B, from row2 down
and you want to conditionally format only col B (CostActual)
based on comparison with col A (CostGoal)

Steps (in xl2003):
Select col B (with B1 active), then apply CF using Formula Is
Condition 1: =AND(COUNT($A1:$B1)=2,$B1<=$A1)
Format Green fill/white font
Condition 2: =AND(COUNT($A1:$B1)=2,$B1$A1,$B1<$A1*1.03)
Format Yellow fill
Condition 3: =AND(COUNT($A1:$B1)=2,$B1=$A1*1.03)
Format Red fill/white font
Ok out

Illustration for the above (with CF dialog screenshot):
http://www.freefilehosting.net/download/3ablf
Conditional Formatting with Percentages.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roady" wrote:
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!