FORMAT SECTIONS OF CELL FORMULA DIFFERENTLY

T

Takeadoe

My cell formulas have gotten fairly complex and I was wondering if
there is a way to perhaps format sections of the formula differently to
make it easier to read. For example, maybe bold everything before the
"+" and underline or something after.

My gut feeling is the answer is no, but it never hurts to ask.

(((PHYD0181-((ASMP01 WNRL_)*HYD0181))*(ASMP01 PHMYD_))*(ASMP01
SNHMAD_)) +

((PHAD0181-((ASMP01 WNRL_)*HAD0181))*(ASMP01 PHMAD_))*(ASMP01 SNHMAD_)

Related to this, is it possible to add CR and LF characters to a cell
formula? It would help if I could break the formulas at the "+" sign,
for example.

Any help is much appreciated.
 
F

Franz Verga

Takeadoe said:
My cell formulas have gotten fairly complex and I was wondering if
there is a way to perhaps format sections of the formula differently
to make it easier to read. For example, maybe bold everything before
the "+" and underline or something after.

My gut feeling is the answer is no, but it never hurts to ask.

(((PHYD0181-((ASMP01 WNRL_)*HYD0181))*(ASMP01 PHMYD_))*(ASMP01
SNHMAD_)) +

((PHAD0181-((ASMP01 WNRL_)*HAD0181))*(ASMP01 PHMAD_))*(ASMP01 SNHMAD_)

Related to this, is it possible to add CR and LF characters to a cell
formula? It would help if I could break the formulas at the "+" sign,
for example.

Any help is much appreciated.
Click to expand...

AFAIK the only thing you can do is to break your formula with ALT + ENTER...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
B

Bernie Deitrick

With a formula, you cannot format the separate parts differently. You can, however, have the two
results appear on separate lines: Format the cell alignment for wrap text, and use a formula like:

= (((PHYD0181-((ASMP01 WNRL_)*HYD0181))*(ASMP01 PHMYD_))*(ASMP01
SNHMAD_)) &CHAR(10)& ((PHAD0181-((ASMP01 WNRL_)*HAD0181))*(ASMP01 PHMAD_))*(ASMP01 SNHMAD_)

Of course, that will result in the formula result being a string.... probably not what you want, but
just thought I would mention it.
HTH,
Bernie
MS Excel MVP
 
T

Takeadoe

I'll settle for ALT-ENTER. Thank you FRANZ!


Franz said:
AFAIK the only thing you can do is to break your formula with ALT + ENTER...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
Click to expand...
 
Top