I need help with conditional formatting.



A B
40 QTD Actual $3,654,317
41 Qtr. Objective $6,332,604
42 % Attainment QTD 57.7%
43 QTD Par % 53.8%


I'm not sure how to code this.

Cell be B43 varies as the monthly sales increase, Cell A40

Condition 1: Formula Is: If cell B42 is greater then B43 change B42 to green. I understand how to fromat the color.

Condition 2: Formula Is: If cell B42 is between .01% and 5% of B43. Change B42 to yellow.

Condition 3: Formula Is: If cell B42 is less then 5% of B43. Change B42 to Red.

Thanks for your help and input.

Is there anyone here that will help?