Prev: Fill handle increments year instead of day
Next: Conditional Formatting Multiple Cells
From: Alicia on 17 May 2010 17:35
Now that I have figured out how to conditionally format one cell, how do I
format multiple cells in the same manner? I've tried using the formatter
"paintbrush" and that just turned all the cells in the column red instead of
those that match the formula.

Formula - if column C is less than column H make that cell red.
From: RagDyer on 17 May 2010 19:47
Post the *exact* formula you used.

I'll bet your problem is the mis-use of absolute and/or relative references.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Alicia" <Alicia(a)discussions.microsoft.com> wrote in message
news:A6B13F85-DDCB-4B21-B401-6CEA796898A3(a)microsoft.com...
> Now that I have figured out how to conditionally format one cell, how do I
> format multiple cells in the same manner? I've tried using the formatter
> "paintbrush" and that just turned all the cells in the column red instead
> of
> those that match the formula.
>
> Formula - if column C is less than column H make that cell red.


 | 
Pages: 1
Prev: Fill handle increments year instead of day
Next: Conditional Formatting Multiple Cells