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

  • Thread starter Thread starter daisyp66
  • Start date Start date
D

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!!
 
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
 
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
 
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.
 
Back
Top