Link to home
Start Free TrialLog in
Avatar of WalterAPO
WalterAPOFlag for United States of America

asked on

Conditional Format to match numbers


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
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
If deleting from the Weekly list put this formula in B2 and fill down:

Open in new window

Then you can filter for the False values in column B and delete those rows.
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.
Avatar of WalterAPO


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.