How can I make a cell red if number is not greater than needed?

[daisyp66]

I have a column that has a goal number. If the number in the next column is
not larger or equal to that goal number, I need the cell to be red. If it is
equal to or larger than the goal number, I need the cell to be green. I just
started using this and need your help please!!

 

[L. Howard Kittle]

Take a look at Conditional formatting under Format.

Format > Conditional formatting > Formula is > =B2<A2 > Format > Patterns >
check red > OK.

Then click Add and do a second condition where formula is =B2>A2 and choose
green from the Patterns.

HTH
Regards
Howard

 

[L. Howard Kittle]

An after thought, if the values are the same then there will be no color, so
you may want to add a third (That's the max number of formats for a cell) to
indicate an equal value color. Formula is > =B2=A2

HTH
Regards,
Howard

 

[Luke M]

Let's say your goal number is in cell B2, and the number you want to color is
in C2. Select C2, then goto Format - Conditional Format. Change the first
dropdown to "Formula is". In the next block, input:
=C2<B2
Click the format box, patten tab, choose red. Ok out.

Add another condition.
Again, change first dropdown to "Formula is". In next block, input:
=C2>=B2
Click the format box, pattern tab, choose green. Ok out.

Ok out.

Done! Note that you could copy this cell to other cells (downward) to apply
similar formatting, if desired.

 

[Gord Dibben]

See help on Conditional Formatting in whichever version of Excel you are
using.

Or see Debra's site.

http://www.contextures.on.ca/xlCondFormat01.html

If stuck, post back with your version of Excel


Gord Dibben MS Excel MVP