Avatar of WalterAPO
WalterAPO
Flag for United States of America asked on

Conditional Format to match numbers

Hello,

There are 2 sheets in the attached spreadsheet.  The 1st sheet, Weekly, has about 3,000 lines and I download this weekly.  The 2nd sheet, Perm, are my numbers.  I tried to use Conditional Formatting find duplicates, but I can’t get it to work.  I need the Conditional formatting to find my number out of the almost 3,000 and then I will delete the other numbers.  

Thank you,

Walter Humko
Bid-Number-Weekly--3-Aug-15.xlsx
Microsoft ExcelVBA

Avatar of undefined
Last Comment
WalterAPO

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
aikimark

to find my number out of the almost 3,000
So, you're trying to find the numbers in the Perm list that are in the Weekly list or vice versa?

I will delete the other numbers
From which worksheet are you deleting rows?
aikimark

If deleting from the Weekly list put this formula in B2 and fill down:
=IsError(Match(A2,Perm!B:B,0))

Open in new window


Then you can filter for the False values in column B and delete those rows.
Subodh Tiwari (Neeraj)

Since this is a regular process for you, I would suggest to go for a VBA solution, you will need to click a button after placing weekly data on Weekly Sheet and your duplicated numbers will be deleted instantly.

Please find the workbook and click on the button Delete Duplicates on Weekly Sheet to delete those numbers from Weekly Sheet which are present in both the sheets Weekly and Perm.

After downloading the workbook, don't forget to enable macros or contents while prompted when opening the file first time.
Bid-Number-Weekly--3-Aug-15.xlsm
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
WalterAPO

ASKER
Thank you this is a very easy solution.   I can share this with my coworkers and it will significatnly reduce the time it takes to update my spreadsheet.   This is hard to pick the best solution, because the others are great too.  

Again, thank you.

Walter