 # Variable Number For Use In Formula Calculations

• I have a formula that will be used by others to obtain a certain result by altering a number in the formula. What I would like to do is make that number obvious as the one that can be changed. The formula reads - "=(M48+P48+Q48)*0.08453-(((J48+K48)*\$K\$4)*0.1)" - what I would like to do is color the 0.08453 in the Formula Bar so it stands out.

Thank you,

cb50chevy

Chuck Behrens

• Re: Coloring A Section Of A Formula

Why not just put that variable in another cell and colour it any which way you like??

All I can see as an alternative is:

=(M48+P48+Q48)+N("Change the next number")*0.08453-(((J48+K48)*\$K\$4)*0.1)

And maybe change your thread title to "Changing Text Colour In The Formula Bar"

• Re: Coloring A Section Of A Formula

You can't do that with Excel, and Yard's suggestion is better anyway.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Coloring A Section Of A Formula

Thanks to Yard & shg for their replies. I will go with Yard's suggestion.

Chuck Behrens

• Re: Coloring A Section Of A Formula

Why not use a named constant? Insert>Name>Define: Name: FixedValue Refers To: =.08453

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!