Cell Formatting

[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.

 

[Eduardo]

Hi,
use conditional formating, highlight the cells, conditional formating, where
the formula is enter

=H2<K2

choose color red

 

[Jacob Skaria]

Use Conditional formatting

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

=K2

 

[Alicia]

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.

 

[Jim]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP