Well you can do it all with a conditional format, however as conditional
formating likes everything to be on the same sheet you need to set up
your range of unique id as a range on the other sheet. Lets say they
are in the range sheet2a1:a10, go to insert_name define and sedt this
range to a name, in my example idrange is the name

then go to the first cell you are interested in for the format, in my
example A1, choose format_conditional formating, formula is
=NOT(ISERROR(VLOOKUP($A1,idrange,1,FALSE)))

and format to whatever colour you wish. this format can be copied to
the cells you wish to apply it to with paste_special formats

Regards

Dav


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