do you have less than or equal to for the first condition? if you accidently
chose greater than or equal to, it will cause the other conditions to fail

"Cali" wrote:

Hi Joe: I can't get number 2 and three to work. I went to the section Cell
value is and not the section where you type in the Formula is. Do you have
any other suggestions.

"joemeshuggah" wrote:



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.