View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DKY[_29_] DKY[_29_] is offline
external usenet poster
 
Posts: 1
Default 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