How to hi-lite a row if data in one workbook matches another workbook

[bradfordsmiths]

In workbook one I have data in column A
In workbook two I have data in column A
I need to see if any of the data in workbook one matches workbook two and for it to hi-lite the entire row in workbook two if it matches. Can anyone help me. Thanks

 

[jim may]

Excel Workbook
	A
1	123
2	234
3	CCC
4	456
5	567
Sheet1

Excel 2007

Excel Workbook
	A	B
1	AAA
2	BBB
3	CCC	MATCH
4	DDD
5	EEE
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B1	=IF(COUNTIF([Book1]Sheet1!$A:$A,A1)>0,"MATCH","")
B2	=IF(COUNTIF([Book1]Sheet1!$A:$A,A2)>0,"MATCH","")
B3	=IF(COUNTIF([Book1]Sheet1!$A:$A,A3)>0,"MATCH","")
B4	=IF(COUNTIF([Book1]Sheet1!$A:$A,A4)>0,"MATCH","")
B5	=IF(COUNTIF([Book1]Sheet1!$A:$A,A5)>0,"MATCH","")

 

[bradfordsmiths]

Thanks that does show which ones match but I also need the rows in book 2 that match book 1 to be hi-lited in yellow. Is that possible?