Use Conditional Formatting from the Format menu as follows:

Select the Open items and select Conditional Formatting from the Format
menu.
Select Formula Is from the 1st drop down menu
Enter =COUNTIF($B$1:$B$17,$A1) in the formula box

where B1:B17 is the Closed item list and A1 is the upper most cell in
the Open item list that you highlighted.

Then click format and pick your formats.

Do the same for the Closed Item list reversing the formula to:

=COUNTIF($A$1:$A$17,$B1)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=538973