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!