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