I have a text search parameter coming from a stored procedure on SQL server. I need the word/phrase the client enters to be highlighted within the case text. Is there a way to do this with conditional formatting. For example:

the best trick I have heard for this is create several formulas that iterate each part that you want: before the highlight, the highlight, after the highlight. Then you can combine all 3 formulas into 1 text field.  Now you can change the color on the highlight section and it all should display as desired.