Excel change font color in formula
I need the following formula to show in RED if it is a negative number.
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"[$$ -409]#,##0.00")
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"[$$ -409]#,##0.00")
Last Comment
ASKER
Nope and it took away the dollar sign.
Try below:
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"[$$-409]#,##0.00_ ;[Red]-[$$-409]#,##0.00 ")
ASKER
Sorry, got the dollar sign back but no red font.
OK try this:
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"$ #,##0.00;[Red]-$ #,##0.00")
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"$ #,##0.00;[Red]-$ #,##0.00")
ASKER
Still not turning red????
Do not use text function, just use your normal formula:
="Budget Variance For Capital Project = "&'SSG 2017 Orders'!AY2
Then Format Cell to [$$-409]#,##0.00_ ;[Red]-[$$-409]#,##0.00
="Budget Variance For Capital Project = "&'SSG 2017 Orders'!AY2
Then Format Cell to [$$-409]#,##0.00_ ;[Red]-[$$-409]#,##0.00
ASKER
That's not working either.
Other way would be;
Using your original formula:
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"[$$ -409]#,##0.00_ ;[Red]-[$$ -409]#,##0.00")
Conditional Formatting as below using formula =Left(H10,1)="-" then format as red font
Using your original formula:
="Budget Variance For Capital Project = "&TEXT('SSG 2017 Orders'!AY2,"[$$ -409]#,##0.00_ ;[Red]-[$$ -409]#,##0.00")
Conditional Formatting as below using formula =Left(H10,1)="-" then format as red font
Of course you need to change H10 as per your cell, where you are having the formula
ASKER
Still not working for me. Not sure what is going on??
Can you upload your file? or send me in pm
ASKER
it works if I take out the text part of the formula.
Finally. Thank God.
That what I proposed earlier:
Do not use text function, just use your normal formula:
="Budget Variance For Capital Project = "&'SSG 2017 Orders'!AY2
Then Format Cell to [$$-409]#,##0.00_ ;[Red]-[$$-409]#,##0.00
That what I proposed earlier:
Do not use text function, just use your normal formula:
="Budget Variance For Capital Project = "&'SSG 2017 Orders'!AY2
Then Format Cell to [$$-409]#,##0.00_ ;[Red]-[$$-409]#,##0.00
ASKER
That doesn't work. The only time I get RED is when there is NO text involved.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got it! :) Thanks!
You're Welcome ssblue! Glad eventually I was able to help :)
The problem was you were using ="Budget Variance For Capital Project = " at the beginning. Format Cell was not treating it as negative.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window