Select the entire column prior to entering the formula.

Make sure you use a relative reference for the rows.

=$l1="T"


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 07:31:02 -0700, EricD
wrote:

Yes, that works. However... I was trying to apply the rule to the entire
column, rather than one cell and then copying. There is already data in the
document, and if I want to add additional rows in the future, I don't want to
have to copy the formatting further down the columns. I hope that makes
sense.

"Sheeloo" wrote:

Add the first condition for cell M1 as
=I1="T" and choose the color

You can have second and third (and more if you have Excel 2007) as the
conditions you already have.

You can then paint it over rest of Col M

"EricD" wrote:

I have conditional formatting on column M based on a dollar value (color
changes highest to lowest). In column I, you can input "D", "F", or "T". If
"T" is chosen, then I want the corresponding cell (same row) in column M to
be a different color than the gradient already being used in the rest of
column M. Basically, if you choose "T" in column I, it would sort of exclude
the corresponding cell in column M my making it stand out as a completely
different color than the rest of the gradient.
Thanks!