Not the greatest at excel, hoping to get a little help.
In B1 I have a data validation list that contains street addresses that includes zip codes and what I would like to do is be able to choose the address from B1 and in D1 to format the cell color and have the town name appear from the zip code in B1 if that makes any sense.
B1 D1
333 andy way 44351 (cell color red) Tommy Town
Any help would be greatly appreciated.
In B1 I have a data validation list that contains street addresses that includes zip codes and what I would like to do is be able to choose the address from B1 and in D1 to format the cell color and have the town name appear from the zip code in B1 if that makes any sense.
B1 D1
333 andy way 44351 (cell color red) Tommy Town
Any help would be greatly appreciated.
