Hi,
I have a cell that calculates a number and a percentage in the same cell.
It needs to look like this. $3,500 (105%)
It calculates using 2 separate formulas like so. <FORMULA1> & "(" & <FORMULA2> & ")"
How do I custom format it so formula 1 shows up as a currency and formula 2 shows up as a %?
If possible I would be able to change the color of the % from Black to red when it goes below 100% but i dont know if that is possible in formatting.
Thanks!
=TEXT(<formula>,"$#,###.00")&" ("&TEXT(<formula2>,"#%")&")"
I do not know of a way outside of Visual Basic programming to perform a partial text format.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
And here's one possibility of what that code might be like:
Please Login or Register to view this content.
Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks