Different formatting in a cell with a concatenated formula?

A

andy2812

Yes, if a1 = blue, and b1 = red, and the formula in cell c1 is =a1&b1,
want the result to look like this: bluere
 
D

Dave Peterson

Formulas don't support this character by character formatting. If you can
convert the results of the formula to values, you can do it though--but that
destroys the formula.
 
Top