C
Cali
Hi everyone: I need your help for I need to know how to do this for work. I
have three condiontions Red, Light green, and Dark green.
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 cell 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 cell
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 cell above and
changes every day. However, the whole number entered into cell B42 only
changes 1 time a month.
have three condiontions Red, Light green, and Dark green.
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 cell 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 cell
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 cell above and
changes every day. However, the whole number entered into cell B42 only
changes 1 time a month.