Excel 2007 : IF/AND TRUE/FALSE and two criteria

i'm guessing that there are many ways to do this, but i cant figure out even one

my aim is to highlight the last row on data set 2 because the condition in data set 1 is TRUE - that is: a project that John finished in 2004.

i cant use conditional formatting because the data sets are in two different workbooks. I've tried using IF and AND but got lost. there are many rows of data in the second data set so i need a forumala that can be entered and copied down. also, i only have a decade range in data set 1 but the actual years are presented in data set 2.

please help - it seems so simple!

data set 1
John 2000s TRUE
John 1970s FALSE
Peter 1990s FALSE
Peter 1980s FALSE

data set 2
Name Finished
John 1-Dec-75
Peter 1-Jan-73
Paul 1-Jun-00
James 1-Dec-70
Isaac 1-Dec-73
John 1-Jul-04 TRUE


thanks to everyone who responds. your solutions to other issues have been an invaluable resource for me. this is actually my first posting for help