Hi, can conditional formatting to be applied to a second word in a cell?
ex:
A
John (mer)
Mary Em (mer)
....

And i need "(mer)" to be red. Just "(mer)".
Can this be done?
Thanks!