If you don't want to copy the format down the column, select the whole of
the column before you define the conditions in CF.
--
David Biddulph

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