Hayitsme may be this could work.
its from Frank Kabel in return of my question, same as your

- define a name for products name like D1:D100 on sheet 2 for all the
unknown products (menu 'Insert - Name - Define). e.g.
call this name 'sourcelist'
- select first cell of all products like A2 on sheet 1
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF(sourcelist,A2)
- choose your format

use this or give us main sheet format that could help me to simplyfy it

thanks
"Hayitsme" wrote:

On one spread sheet i have all available products.
On the other spread sheet i have a unknown list of products which are
contained in the first spread sheet.
How can i set up a formula to show me all the products not listed on the 2nd
form?