Concantenating 2 cells =C6 & " (" & C189 & ")" C6= 2,359 C189 = -9.85%
=TEXT(C8,"#,##0") & " (" & TEXT(C191,"0.00%") & ")"
This works fine to give me 2,359 (-9.85%) but I WANT THE -9.85% to be RED.
I tried =TEXT(C6,"#,##0") &" (" & TEXT(C189,[red][>0];[black][<=0]"0.00%") & ")" but was unsuccessful
Any ideas???
Last edited by Babbabooie; 07-11-2014 at 12:33 PM.
2,539 (-9.85%) d6: =text(c6, "#,##0 (") & text(c189, "0.00%)")
Entia non sunt multiplicanda sine necessitate
Perhaps
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Awesome thanks! 1 more.... How do make the percentage red?
You can't, without using VBA.
Please don't edit your posts and change your question and thread title after people have responded to the original one -- it makes it very confusing for people that read the thread later.
Last edited by shg; 07-11-2014 at 01:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks