Using an If Formula with Conditional Formatting

C

Cali

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering an If formula using conditional formatting 2
Writing Formula For conditional Formatting Using Excel 2000 3
Cumulative formula for word table 0
Found few bugs in my daily routine of work in excel for MAC 0
Help with a formula 4
Found few bugs in my daily routine of work in excel for MAC 0
Conditional Formatting Cells 1
Can result of formula not display if =0 3

Top