Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Compare worksheet columns | Excel Worksheet Functions | |||
compare two columns and remove duplicates | Excel Worksheet Functions | |||
can't insert columns between columns | Excel Discussion (Misc queries) | |||
format columns to collapse and expand in excel | Excel Discussion (Misc queries) | |||
compare columns of different worksheets | Excel Discussion (Misc queries) |