Hi
One way would be to use conditional formatting. But because conditional
formatting cannot reference other worksheets you will have to use range
names. Start by selecting your data in sheet B, once you have selected,
type a name in the name box left of the formula bar.....say "list", then
select your data in sheet A, goto FORMAT/CONDITIONAL FORMATTING select
FORMULA IS and type:
=AND(COUNTIF(list,$A1)0,COUNTIF(list,$B1)0)
choose your format....say red background

A1 and B1 represents the first column and row of your data in sheet A,
ajust accordingly

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=477318