Hello,

I hope somebody can help me out with this questions.

1th question:
In sheet1 there is a list with names in range B10 till B...(last used
record).
In this sheet there is also by a few names in kolom A10 till A...(last
used record) registrated the letter "O".
So we have for example:
A B
record 10 O Pietersen
record 11 Jansen
record 12 O Klaasen
record 13 Huisma

In sheet2 in range A2 till A.. (last used record) are also names
registrated.
I need a macro that coloring red the datafield in sheet2 if this name
is not on the list in sheet1 and if the name is registrated on the
list but there is no letter O registrated before it in kolom A it
should be coloring yellow.

2th question:
In a specific kolom (format "number" with 0 decimals) the user should
registrate a four digit number with the number format. If there is
registrated something differents (more or less numbers or a
dateformat) the datafield should be coloring red.

If somebody can help me........
Thanks a lot.

Regards,
Johan.
The Netherlands.