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

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!!

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

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 =B2A2 and choose
green from the Patterns.

HTH
Regards
Howard

"daisyp66" wrote in message
...
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!!

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

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

"daisyp66" wrote in message
...
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!!

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"daisyp66" wrote:

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!!

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

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



On Wed, 2 Dec 2009 10:44:01 -0800, daisyp66
wrote:

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!!