Compare 2 columns & format row
 

I am not sure which function to use - vlookup, countif, or match. Can
someone help?

File #1 - column A: list of values (values & # of rows change daily)
column T: blank

File #2 - column A: list of values (value & # of rows change daily)

If a value in File #1 column A is found anywhere in File #2 column A, I
would like to color the corresponding row in File #1 blue and put an X
in File #1 column T. The color is actually something that would be
nice but not required.

Thanks in advance for any help!!!

Lia


--
moremetrics
------------------------------------------------------------------------
moremetrics's Profile: http://www.excelforum.com/member.php...o&userid=23537
View this thread: http://www.excelforum.com/showthread...hreadid=381357

in T1 file 1 enter

=if(not(iserror(match(a1,[file 2]sheet1!A:A,0)),"X","") and copy down to the
end of the data
select all in File 1
in conditional formating
formula is =$T1="X"
and set your formating
note you may have to go back into conditional formating a time or two to
make sure there are not extra Quote marks and that relative formating is
correct. I don't know why it gets goofed up sometimes, but it alwasys has
for me.

"moremetrics" wrote:


I am not sure which function to use - vlookup, countif, or match. Can
someone help?

File #1 - column A: list of values (values & # of rows change daily)
column T: blank

File #2 - column A: list of values (value & # of rows change daily)

If a value in File #1 column A is found anywhere in File #2 column A, I
would like to color the corresponding row in File #1 blue and put an X
in File #1 column T. The color is actually something that would be
nice but not required.

Thanks in advance for any help!!!

Lia


--
moremetrics
------------------------------------------------------------------------
moremetrics's Profile: http://www.excelforum.com/member.php...o&userid=23537
View this thread: http://www.excelforum.com/showthread...hreadid=381357

This worked perfectly. I REALLY appreciate it!


--
moremetrics
------------------------------------------------------------------------
moremetrics's Profile: http://www.excelforum.com/member.php...o&userid=23537
View this thread: http://www.excelforum.com/showthread...hreadid=381357