Forum Discussion
Finding Matches in List of Zip Codes
Subodh_Tiwari_sktneer I posed the question wrong - I can only offer lodging for those OUTSIDE of a 30 mile radius - so sorry! I'd like to format the cells in column D when they have a match to any of the cells in column G. Thank you again for your help!
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.