Create a UDF

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

and use that in conditional formating to highlighte them.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mare" wrote in message
...

Thanks for the quick reply,
I did not explain that I would like to have highlighted cells color
coded, and also to be able to select different result cells within the
same worksheet at the same time.


--
Mare
------------------------------------------------------------------------
Mare's Profile:
http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=505994