Format the color some of the text but cell contains formula

[myoung84]

So I'm trying to change part of the text in a cell but can't figure it out because it contains a formula.

On an input tab I have several options to type or select options. On my quote tab that I print for customers I have all of these listed out in a table format with a formula that pulls in the data from the input tab.

Here's an example.

Input Tab:
Voltage: (drop down menu) 120/208V

Quote Tab:
(How it looks) Voltage: 120/208V
Formula: ="Voltage: "&E8

I want the Voltage: to be black and the value (E8 / 120/208V) to be red.

Is this possible?

[6StringJazzer]

It's not possible if the cell contains a formula.

[myoung84]

It's not possible if the cell contains a formula.

Got it. I guess the alternative is to make a ton of 10px wide columns and try to get everything to lineup the best I can.

[Rick Rothstein]

The alternative is to probably use VBA event code to mimic the action of your formula. Can you post your formula (for the first cell in the range), and the address of the range, so we can see if this is possible for it?