Automatically change number color based on +/- within text string in one cell

[RP04]

Hello!

I have a tried multiple different solutions but have not been able to make this work yet (including trying to write a VBA code)

I am trying to change the color or negative numbers to red inside a cell that also contains text/other formulas. This was the latest and what I thought would have been the simplest solution.

="Example ABC " & Text(-3000,(#,##0.00_);(#,##0.00))
(goal is to change -3000 to red and also put a comma in)

*reason I cannot just highlight the negative numbers and change to red it that there are hundred of lines with text in the formula, too manual and chance of human error.

 

[Fluff]

Hi & welcome to MrExcel.
If the cell contains a formula, you cannot (afaik) change the font colour for part of the cell

 

[RP04]

Hi & welcome to MrExcel.
If the cell contains a formula, you cannot (afaik) change the font colour for part of the cell

Hello - What if I copy/paste as values but it is all still inside one cell (text and numbers)?

 

[Fluff]

Then you can format it with a macro.
Would always be just -3000 that needs to be changed to a red font?

 

[RP04]

Then you can format it with a macro.
Would always be just -3000 that needs to be changed to a red font?

It would be different numbers in different cells every day in various formats (-XX%, -XX.X ppts). I tried creating a macro but was having difficulting getting it to work on different numbers instead of just the same numbers

 

[Fluff]

Can you post some examples of the data in the cells, showing what you want highlighted.
Also what are the cell ranges?

 

[RP04]

Can you post some examples of the data in the cells, showing what you want highlighted.
Also what are the cell ranges?

Cell ranges between E6:BE22. See images below

 

[Fluff]

Is there any reason why the value in A1 is not red, as that is also a negative value?