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.