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

"Alicia" wrote:

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.

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.

"Eduardo" wrote:

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

=H2<K2

choose color red

"Alicia" wrote:

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.

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

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

"Eduardo" wrote:

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

=H2<K2

choose color red

"Alicia" wrote:

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.

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


Gord Dibben MS Excel MVP

On Thu, 13 May 2010 10:20:05 -0700, Alicia
wrote:

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.

"Eduardo" wrote:

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

=H2<K2

choose color red

"Alicia" wrote:

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.

Use Conditional formatting

Select H2 and from menu ..FormatConditional formatting Cell Value Is
lessthan

=K2


--
Jacob (MVP - Excel)


"Alicia" wrote:

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.