Conditional formatting - getting input from another cell

[EricD]

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!

 

[Sheeloo]

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]

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.

 

[David Biddulph]

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.

 

[Sheeloo]

You can select the whole column and then apply the conditional formula...

or you can select a range and add the formula referring to the first cell in
the range...
it will be applied to new rows too if you insert them

 

[Gord Dibben]

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

 

[EricD]

Actually, I figured it out through trial and error before I came back and
read this. I had no idea the answers would come so quickly. Thank you! But
yes, the "$" was the key. I had already chosen the column letter, but didn't
know how to tell it that if ANY cell in column I had a "T", then it should
just change it's corresponding buddy over in column M.