i have a list of post codes (no other data) on worksheet 2 when i use
a drop down list to select the postcode from worksheet 1 i need to
cross refrence this data with data in worksheet 2

then if a match is found show as true ( in a designated cell) and if a
match is not found false (in a designated cell) or the cell showing the
post code could change colour IE: blue for match and red for mismatch


thanx


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=519107