Zend certified PHP/Magento developer

colour part of the output from a formula

One cell has a formula:

=CONCAT("a","b")

in which “a” is a character string but “b” is in reality a value from another function.

I was asked to colour “b” red and keep “a” black. How do I do this?