"Dave Peterson" wrote:

Say your data is in A2:Axx.

Insert a new column B and put a formula like:

=if(a2="his","<--Male--","<--Female--")

or anything you want:
=if(a2="his","<--Male--","")

so that the males stand out more (which is right and proper, oh, oh!)


Thankyou for your explanation. Sorry for not seeing the light!

Now, I understand your response. Thankyou. I will try that, but I think that
it won't be what 'they' want.

Do you think it is possible to insert via formula or macro an image into a
cell or cells?

You should know that this form does not require data to be stored or
accessed, except via formula, or if it requires data to be retrieved from
another sheet that is 'organic' to the form. It is a 'free standing' form.

Thankyou for your time and effort.