How to keep conditional formatting colors while concatenating

[Nlhicks]

I am using this table that has all of my conditional formatting with this formula: =CONCAT("(",J9," ", L9," ", "",M9, "[",M10,"]"," ",N9," ",","," ", J11," ",L11," ",M11, "[", M12,"]"," ",N11,")")

I am getting this result:

What I need is for the colors in the table to travel with the concatenation so I can automatically create an email from excel and send it to the appropriate channels any suggestions?

 

[Joe4]

Excel formulas can only return values, not formatting from other cells (especially not Conditional Formatting).
What is the Conditional Formatting rule on these cells that is coloring these other cells in the first place?
Can you apply a similar Conditional Formatting rule on the cells with this formula?

I should also note, even if you are able to do this, I have no idea if those colors can be transmitted to an email (you really have two related, but separate questions here).

 

[Nlhicks]

Maybe that would be possible, Thanks for the suggestion I will try it

 

[Joe4]

You are welcome.

Note that when marking a reply as the "Solution", you want to select the actual post that contains the solution (and not some other post indicating that another post is the solution).
The point of marking a post as the "Solution" is that so anyone else can read the initial question, and then jump right to the post that contains the solution.
I have updated it for you.