Hi
why don't you use conditional formating. Try the following
- select the cell (lets assume A1)
- enter the comparison that cell < "[Enter Text]"
- chose your format (black)
- enter a second condition for cell = "[Enter Text]"
- choose your format (red)

--
Regards
Frank Kabel
Frankfurt, Germany


Todd wrote:
I have a group of cells which contain the text "[Enter
Text]" and their color is set to Red. I would like the
text of these cells to change to Black after the new text
is entered in each cell.

I've been able to make them ALL change after the first
cell is changed, but I would like them all to change
seperately. Any suggestions?

TIA