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