condition 1
cell value is, less than or equal to, =$B$43

condition 2
cell value is, between =$B$43+(0.01*$B$43), =$B$43+(0.2999*$B$43)

condition 3
cell value is, greater than or equal to, =$B$43+(0.3*$B$43)

"Cali" wrote:

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.