Writing Formula For conditional Formatting Using Excel 2000

  • Thread starter Thread starter Cali
  • Start date Start date
C

Cali

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.
 
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)
 
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.
 
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
 
Back
Top