Greetings, all -

I am creating a simple spreadsheet template to be distributed to users
for data entry purposes. The first column contains the names of the
desired data elements. The second column contains the definition for
each data element. The definitions are formatted in red text. I intend
for the user to remove the definition and replace it with the proper
information for each element. For example:

Data Element Definition
1.0 LastName The last name of the person to whom questions
about the sample should be directed.

The user would replace the definition with, say, "Smith" using the usual
method for overwriting data in a cell (i.e. click'n'type). Once the
definition has been overwritten and the user hits Enter, I would like
for the font color to change from red to black. Here's the rub...this
has to be done without macros or VB of any kind. I'm hoping to use
Conditional Formatting combined with some native formula that I have yet
to identify; something like the "IS" functions, perhaps? Alas, if only
there was such a thing as ISNEW()...

Ideas?

tia,

LeAnne