Perhaps i'm misunderstanding what active cell means, I don't want that to be
the choice in only that one cell, i want it to look in a group of cells and
where ever it find mcr, i want the mcr to be turned red.
I'm going to try what you gave me and i'll write you back with my
sucess.
thanks.
--
NealMed


"Bob Phillips" wrote:

Just use

=C6="MCR"

assuming that C6 is the active cell, and copy to the rest, Excel will adjust
it


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"NealMed" wrote in message
...
I have the following two formulas for the same area the first works the
second does not.
=C$5<ROW()-5
=C$6:$I$14="MCR"
The first one places a color in a group of cells unless a drop down menu
gives it a different number of cells to cover.
What i want the 2nd to do, is to have in that same grouping of cells,
change
the color of the font to red if the letters MCR are in that cell.
What did i do wrong in my formula.
Thanks for your help.
Neal.
--
NealMed