Help with getting two cells to match based on cell color and adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1999804%22%20slang%3D%22en-US%22%3EHelp%20with%20getting%20two%20cells%20to%20match%20based%20on%20cell%20color%20and%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999804%22%20slang%3D%22en-US%22%3E%3CP%3ELet%20me%20start%20by%20saying%20I%20am%20far%20from%20an%20Excel%20expert%20so%20please%20dumb%20it%20down%20for%20me...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20a%20quick%20way%20to%20get%20two%20cells%20that%20are%20different%20in%20column%20A%20to%20match%20based%20on%20cell%20background%20color%2C%20if%20the%20data%20in%20column%20be%20that%20is%20adjacent%20is%20duplicated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20way%20to%20describe%20it%20is%20to%20show%20you%20a%20screenshot...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jsminchak_0-1608243389990.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241464i06AA6F4FD1C5D8BB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jsminchak_0-1608243389990.png%22%20alt%3D%22jsminchak_0-1608243389990.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20the%20data%20in%20column%20B%20is%20duplicate%2C%20then%20I%20want%20the%20number%20in%20column%20A%20next%20to%20it%2C%20that%20is%20highlighted%20yellow%20to%20copy%20to%20the%20other%20cell%20that%20matches%20the%20duplicate%20cell%20in%20column%20B.%26nbsp%3B%20How%20do%20I%20do%20that%3F%26nbsp%3B%20I%20don't%20want%20to%20go%20through%20this%20manually...%20there%20are%20over%203000%20rows.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1999804%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2000147%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20getting%20two%20cells%20to%20match%20based%20on%20cell%20color%20and%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2000147%22%20slang%3D%22en-US%22%3E%3CP%3ENevermind.%26nbsp%3B%20I%20figured%20it%20out%20with%20an%20IF%20logic.%26nbsp%3B%26nbsp%3B%3DIF(B2%3DB3%2CA3)%26nbsp%3B%20I%20am%20surprised%20I%20had%20this%20many%20views%20on%20this%20post%20and%20no%20replies%2C%20and%20an%20Excel%20noob%20like%20me%20figured%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Let me start by saying I am far from an Excel expert so please dumb it down for me...

 

I am trying to find a quick way to get two cells that are different in column A to match based on cell background color, if the data in column be that is adjacent is duplicated.

 

Best way to describe it is to show you a screenshot...

jsminchak_0-1608243389990.png

If the data in column B is duplicate, then I want the number in column A next to it, that is highlighted yellow to copy to the other cell that matches the duplicate cell in column B.  How do I do that?  I don't want to go through this manually... there are over 3000 rows. 

1 Reply

Nevermind.  I figured it out with an IF logic.  =IF(B2=B3,A3)  I am surprised I had this many views on this post and no replies, and an Excel noob like me figured it out.