I have a Long text control out putting to a report as rich text format named [ChangeRequested]. I would like to change the color of a text based on a key word.
Examples in Text:
Green Text
Red text
Brown text
I know I can activate using the Conditional Formatting using Expression is [ChangeRequested] like "* Red text *" then change the settings for the text. Simple. What I would like to do is to be able to change the color only for the words "Red text" and keep all other characters the same black text.
Examples in Background color change
Shade Blue
Shade red
Shade Yellow
Shade Green
I know I can activate using the Conditional Formatting using Expression is [ChangeRequested] like "* Shade Green *" then change the settings for the background. Same as above, I only want the key words to have the background change. It may be called highlighting.
How would I go about this? I think it might be easier if its in VBA. Suggestions please.
Thanks