Hi Everyone: Does anyone know how to write three seperate formulas for these
questions in the conditional formatting box Using Excel 2000?

1?: Red. If the value that is calculated in cell B42 is = to or less then
the value in Cell B43 turn Cell B42 Red. Actual value in cell B42 and B43 are
whole numbers

2?: Light Green. If the value that is calculated in cell B42 is between 1%
and 29.99% greater than the value in Cell B43 turn Cell B42 light green.

3?: Dark Green. If the value that is calculated in cell B42 is greater by
30% or more then the then the value in Cell B43 turn Cell B42 dark green.