Cell Formatting

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

Is there a way to format a number cell to change to red fonts if less than
another cell?

Ex: Cell H2 is 29 which is less than Cell K2 which is 35.

I would like to drag a formula down column H to change to red if the value
is less than column K.
 
Hi,
use conditional formating, highlight the cells, conditional formating, where
the formula is enter

=H2<K2

choose color red
 
Use Conditional formatting

Select H2 and from menu ..Format>Conditional formatting> Cell Value Is>
lessthan>

=K2
 
Thanks, that worked! Now, do you know how I can copy to all cells below? I
tried dragging down the same as I would a formula but it just copied. I'm
pretty good with dragging formulas so I'm confident that I'm doing that part
correctly.
 
On the standard toolbar (excel 2003) there is an icon that looks like a
paintbrush. It's called a format painter. Highlight the cell where it
worked, and click on the paintbrush, and "paint" the formatting to the other
cells by dragging the brush down.

Jim
 
Make sure Excel has not "helped" you by adding $ signs to the formula.


Gord Dibben MS Excel MVP
 
Back
Top