Hi

I have a spreadsheet which i use to keep a record of stock in a shop and it
has two tabs one for stock in store and another for obsolete stock. on sheet
one i have a list of product codes and a description and on sheet two there
is the same. how can i make the colums on sheet one ie. the product code and
description show up red if the product appears on sheet 2?

many thanks

phill