Please can you tell me how to put colour references into a formula.
e.g
If
A1=Fred and B1=Smith
then
C1= Fred Smith.
("Fred" in red text, "Smith" in green text)

Thanking you in anticipation.
--
Big Rick