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
Bookmarks