how to show growth/degrowth symbol (up/down) with color in text formula

[Pankaj jaswani]

Hi,

I am writing a conclusion report with showing the figures. If any figures in negative/positive then i have to show the up or down sign for growth or degrowth (with green or red colour also). I can add the sign, but I'd like to modify the colour as well. I know the colour can be adjusted using the custom format option, but because I'm writing text and showing figures, I'm not sure how to show them in colour. Please assist me with this if anyone is aware of it.

[Pankaj jaswani]

@AliGW Greetings. Ma'am, Could you please help me to move this thread under formula & function module?

[menem]

Maybe condition format , detected for (- sign?

Regards.

[Pankaj jaswani]

Thank you for replying, but it is Not working..

[AliGW]

That's not a suitable or useful response. Define "not working". You should know better ...

[Pankaj jaswani]

Thank you for replying, but it is Not working..

It does not work because it detects the entire line as condition format rather than just one word or condition.

[AliGW]

You will probably need VBA for this.

[Pankaj jaswani]

Ma'am, VBA is also acceptable. Could you please assist me in obtaining the result using VBA coding? I will be eternally grateful to you.

And if VBA is helpful to get this result then can we also bold the text which are under small brackets ().

[AliGW]

I can only help you by moving this to the VBA section, which I shall do now.

[Pankaj jaswani]

Okay ma'am. Thank you so much. I'm hoping a vba expert or guru can assist me with this.

[HansDouwe]

Without an example sheet it is quite difficult to indicate all possibilities.

Is the -6.4% fixed in another cell or is it a calculation, then it can probably also be done with conditional formatting.
Could you therefore add an example of your Excel file.

[Pankaj jaswani]

Hello, HansDouwe!! Thank you for your response to this post. Yes, it is a calculation, but it is concatenated with text formulas as shown in the screen shot. I just want any number or percentage under () to be bold, and any percentage with a symbol up/down indicating growth or degrowth to have the font colour changed to Green or Red with bold.