Hi Phill,

First insert a name, say Obsolete, and define its reference like Sheet2!A:A
(say product code is in column A)

Select Sheet1 Column A, Conditional formatting/Formula:
=NOT(ISERROR(VLOOKUP(A1,obsolete,1,FALSE)))
Choose red color, OK

Regards,
Stefi


€žphill€� ezt Ã*rta:

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