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?

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?