Unfortunately my list is longer ... no idea how to use a macro. Anyway
thanks a lot.
--
Ille


"Joel" wrote:

Conditional formating will allow you to select a difffeent color for up to 3
different items. If your listt is greater than 3 you require a macro.

"Ille" wrote:

Hi All,
I'm working wiht Excel 2003 and trying to set up a form. I will allow
entries to be selected from a list - so far no problem. Is it possible to
format the entries in advance, i.e. that for example, if you selcet "name"
from the list, it will appear in red?
Thanks for your help
--
Ille