Hi,
My question may look like a simple one but here it goes:

combining cell contents via formulas such as
C10=A20&" ("&B40&")"
is simple and straight forward enough.

But can I manage to display cell B40 contents using a different color (say
red) then cell A20 content in C10 programmatically?. In target cell C10
where cells A20 and B40 contents are to be merged I need to see cell A20
contents in default color, but cell B40 contents in red.
An example will be much appreciated.
TIA
J_J