Hi and thanks for the help.
I have a formula that reads: =TEXT(VPS!L23,"$#,###")&" "&TEXT(VPS!N23,"+0.0%;-0.0%") which yeilds $30,563,920 -12.1% in one cell. I can not get the number format to respond to a RED text color for negative numbers. Any thoughts?
Thank you ~
J
I have a formula that reads: =TEXT(VPS!L23,"$#,###")&" "&TEXT(VPS!N23,"+0.0%;-0.0%") which yeilds $30,563,920 -12.1% in one cell. I can not get the number format to respond to a RED text color for negative numbers. Any thoughts?
Thank you ~
J