Hi Anthony,

This can be easily done using another column, eg if your lists are i
column A, enter the following in cell B2 of the "all NFL Players" shee
& copying it down:
=COUNTIF('Draft Board'!$A$1:$A$4,'All NFL Players'!A2)

Using conditional formatting directly is a little harder b/c if the
are on separate sheets but it can be done using a named range eg ente
this in cell A2 of the ALL NFL Players sheet:
=COUNTIF(DraftList,'All NFL Players'!A2)0
Where "draftlist" is a defined name that contains all of the cells i
the list on the "Draft Board".

sorry, am off to bed - hope I have included enough detail?

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience..

--
broro18
-----------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=53846