Hi guys,

I've been trying to think of a appropriate algorithm to do the following.

I have a list of formula in text (in one column).

E.g. in cells A1:A3

'These are all texts, not actual formulae 
Please Login or Register  to view this content.
I want to dissect them and identify whether it is an actual cell reference (say make it blue), and hardtype values (say, make it red)

I.e. Result should look something like...

=Bananas!A$1 + Apples!$B$3 + 'Red Apple'!$B8
=IF(A1=5,B1,"This is not a 5")
='[Awesome Fruits]Mango'!A5 + 2