I've just inherited a large sheet with thousands os entries. In keeping with other sheets, I want to be able to:

(i) select an area
(ii) run the macro
(iii) have the macro change the font colour to blue if hardcoded, black if linked and keep red if already red.

I need all existing formats to be untouched (highlighting, bolding etc)

Thanks

Will