I attempting to develop a spreadsheet that will compare the first three numbers in one column with the first three numbers in another.
The project i am doing is related to zip codes and need to be able to compare.
For example -
Zip code in Milwaukee - "53217"
First three digits for that part of the country - "532 - midwest"
I would like to use conditional formatting, but not sure how to create the formula.
Thanks.
Bookmarks