I am trying to show a shaded area that is a set distance (2.5 or 5 miles etc) from the coast is Florida - The reason is that we do not want to see any business from this area - and by having a line or shaded area at the set parameters will allow us to do this. I have been looking for Lat Long calculations in XL too and am still having no luck.

Thanks

Dingo