Hi Experts,
I have list of Zip Codes, I want to highlight Column B Zip Codes which are available on Column C, Column B have 112000+ zip codes and Column C have 700+ Zip Codes, any expert can help me on this issue?
Attched: Excel file
Thanks in Advance
Farhan
here excel file
You can use conditional formatting in B2 and down...
Conditional Formatting
- Highlight applicable range >> =$B$2:$B$14291
- Home Tab >> Styles >> Conditional Formatting
- New Rule >> Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =ISNUMBER(MATCH(LEFT(B2,5)+0,C:C,0))
- Format… [Number, Font, Border, Fill]
- OK >> OK
Last edited by jeffreybrown; 05-30-2018 at 02:25 PM.
HTH
Regards, Jeff
If you sort col c, you can use a much faster CF formula:
=LOOKUP(--LEFT(B2, 5), $C$2:$C$706) = --LEFT(B2, 5)
Zip Code Excl Zip 33407-1904 32182-0437 32182-0437 33407-1904 32182-0437 32667-3941 32667-3941 34481-8922 32667-3941
Entia non sunt multiplicanda sine necessitate
The entire range is: =$B$2:$B$42398
For CF use this:
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks