Concatenate data into one cell and format numbers

[jmartell]

I am trying to concatenate 2 cells together. Cell A is a dollar amount and cell B is a percent. When I concatenate these I get a big long number. I have tried using the TEXT function but I can not get the negative numbers to respond to RED formatting. Does anyone know a way to do this to keep the numbers true numbers and get the right formatting? I want negative numbers to respond to RED.

This is the result I would like to achieve!
Cell A: $1,000 Cell B -25% Cell C = $1,000 -25%[RED]

Thank you!

 

[Andrew Poulsom]

Sorry, but you can't apply rich text formatting to the result of a formula.

 

[pgc01]

Hi jmartell

If you really need this functionality you can implement it in vba with the change event.

Hope this helps
PGC

 

[jmartell]

Thank you for the suggestion! I will attempt it

J