Using an If Formula with Conditional Formatting
 

Using Excel 2000; Hi everyone, Help please

1?: Red. If the value that is caluculated in cell B41 is =to or less then
the value in Cell B42 by 1% turn Red. Actual value in cell B41 and B42 are
whole numbers. B42 is a sum of several cells above and changes every day.
However, the whole number entered into cell B42 only changes 1 time a month.

2?: Light Green. If the value that is caluculated in cell B41 is = to or
greater then by .2999 then the value in Cell B42 turn light green. Actual
value in cell B41 and B42 are whole numbers. B42 is a sum of several cells
above and changes every day. However, the whole number entered into cell B42
only changes 1 time a month.

3?: Dark Green. If the value that is caluculated in cell B41 is = to or
greater then by 30% then the value in Cell B42 turn dark green. Actual value
in cell B41 and B42 are whole numbers. B42 is a sum of several cells above
and changes every day. However, the whole number entered into cell B42 only
changes 1 time a month.

Using an If Formula with Conditional Formatting
 

See the reply to your message in another group. Please don't multipost.
--
David Biddulph

"Cali" wrote in message
...
Using Excel 2000; Hi everyone, Help please

1?: Red. If the value that is caluculated in cell B41 is =to or less then
the value in Cell B42 by 1% turn Red. Actual value in cell B41 and B42 are
whole numbers. B42 is a sum of several cells above and changes every day.
However, the whole number entered into cell B42 only changes 1 time a
month.

2?: Light Green. If the value that is caluculated in cell B41 is = to or
greater then by .2999 then the value in Cell B42 turn light green. Actual
value in cell B41 and B42 are whole numbers. B42 is a sum of several cells
above and changes every day. However, the whole number entered into cell
B42
only changes 1 time a month.

3?: Dark Green. If the value that is caluculated in cell B41 is = to or
greater then by 30% then the value in Cell B42 turn dark green. Actual
value
in cell B41 and B42 are whole numbers. B42 is a sum of several cells above
and changes every day. However, the whole number entered into cell B42
only
changes 1 time a month.