Hi, I am using excel 2007 and have a large list data in a single column that is hyperlinked. however many in this list may have the blue font color like the hyperlinked ones but have no url associated with them.

What I need to be able to do is have excel locate all these false linked cells and change there font color to normal then from there I can sort everything by font color and makes it easy to find and fix these fields.