if numbers match then color row
 

I need my hand held as I walkthrough this one. I want to run a macro or
program something that says if a number in column a on worksheet 2
exists in column a on worksheet 1 then color the whole row in worksheet
1 that the number/s exist on. It may also be that this number may have
several occurences on worksheet 1. Where would I begin to program
this?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=384868

if numbers match then color row
 

Personally, I would use an extra column. Then I could apply
data|filter|autofilter and show the items I wanted.

You can't do this kind of thing with colors.

Do this in Sheet1.
Insert a new column (A???).

In A2 (headers in row 1???).
=isnumber(match(b2,sheet2!c:c,0))

Then drag down.

===
If you really wanted colored rows, take a look at format|Conditional formatting.





DKY wrote:

I need my hand held as I walkthrough this one. I want to run a macro or
program something that says if a number in column a on worksheet 2
exists in column a on worksheet 1 then color the whole row in worksheet
1 that the number/s exist on. It may also be that this number may have
several occurences on worksheet 1. Where would I begin to program
this?

--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=384868

--

Dave Peterson