Prev: FILTERS
Next: Macro
From: Gord Dibben on 13 May 2010 18:40
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
<Alicia(a)discussions.microsoft.com> 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.

First  |  Prev  | 
Pages: 1 2
Prev: FILTERS
Next: Macro