Forum Discussion
Finding Matches in List of Zip Codes
I have a list of zip codes in row D that attendees of a conference have entered. We can only provide lodging for those within a 30 mile radius of the conference. In row G, I have all zip codes that a...
What did you try which didn't work?
If all you want is to highlight the Zip Codes in Column D if they are found in Column G, the formula I suggested will work. Please refer to the attached in which I have applied the conditional formatting to the range D1:D100. Isn't it what you are trying to achieve?
Also, please avoid posting image of the data, no one likes to retype the data if a file is required to show that the proposed solution works properly. It's always a good practice to upload a sample file instead of an image.
Subodh_Tiwari_sktneer This worked, thank you!
You're welcome kristensemple1290!
Please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.