Conditional formatting - getting input from another cell
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!
|