Format Rule for a part of the text

I'm wondering if it possible to use format rule for a part of the text. 

So i got the following text in a column: 

="Some text "&[Column 1]&" Some text "&[Column 2]&" Some text 3"

( I eat [meat balls] and [vegetables] every Monday) 

I want to apply the format rule for a [Column 2] text-part.

If I use Formate rule for a Column 2 , it won't work after CONCATENATE() function.

Please help if there any trick to reseave the following result: 

="Some text "&[Column 1]&" Some text "&[Column 2]&" Some text 3"

( I eat [meat balls] and [vegetables] every Monday) 

0 4 226
  • UX
4 REPLIES 4
Top Labels in this Space