change linked cells to black, hardcoded to blue
 

I've just inherited a large sheet with thousands os entries. In keepin
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, blac
if linked and keep red if already red.

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

Thanks

Wil

--
Romanian3
-----------------------------------------------------------------------
Romanian37's Profile: http://www.excelforum.com/member.php...nfo&userid=975
View this thread: http://www.excelforum.com/showthread.php?threadid=50887