Changing the font color of one word within a concatenate

Hi! I have an issue that's been bugging me for a few days - that is, how can I change the font color of one word within a concatenate formula? I've searched and only found how to change the cell color, but what I'm looking for is how to change the color of a percentage. Here's my basic formula:

=Concatenate(A12, " students represent", B12, "% ", "of the population")

What I'm looking for is a way to change B12 (a number in the original cell) and "%" to a bright blue font, and leave the rest black. The result will dynamically change based on data in A12 and B12 (both of which are formulas), and sometimes B12 will be 1% or sometimes it will be 100%, so there's variable length involved. Is there any way to do this?

Thank you!

Hi and welcome

Reason you cannot find a solution is it cannot be done, at least not with a formula alone. You could do it with VBA..

BSB

Thank you for the reply!