You use conditional formating, but unfortunately it can not directly
access a range on the other sheet, so firstly you have to name this
range, it may be better to make it larger than your data currently to
allow for expansion

you do this by insert name define if you called this range test and on
the other sheet were looking at the value in cell a1.

Goto conditional formating choose formula is and type
=VLOOKUP(A1,test,1,FALSE)0 and format the cell as red

This format can be pasted as a format to the other cells where you need
to apply the logic

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563625