Thanks for the info....Could not download compare2sheets.zip. Would you send
it to ???? thanks!

"Excelenator" wrote:


You can use a formula that you insert into todays sheet in a blank
column to lookup the id number or any other identifying data for a
record and then use conditional formatting based on the result of that
formula.

Formula
=ISERROR(VLOOKUP(A2,'7-25-06'!$A$2:$C$5,2,FALSE))

I've attached a file that contains two sheets (you can change this to
to separate files) and compares the first sheet to the next using the
formula above and then applies conditional formatting to the data that
is not contained on the old sheet.


+-------------------------------------------------------------------+
|Filename: compare2sheets.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5107 |
+-------------------------------------------------------------------+

--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565161