Hi LeAnne,

Hopefully this will make things clearer.
http://www.andypope.info/ngs/ng35.htm

If I have mis-understood let me know.

Cheers
Andy

LeAnne wrote:
Andy Pope wrote:

Hi,

Could you not use an additional column that is a copy of the
Definition, call it masterdefinition. This column can be hidden.
Then when the user changes the definition you can use a CF to test
their definition against masterdefinition.

Cheers
Andy


Andy, not sure at all that I follow you. How could "Smith" be tested
against "The last name of the person to whom questions about the sample
should be directed"? Other than cofirming that the replaced defitintion
ISTEXT or something.

Puzzled,

L.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info