Conditional formatting

[puiuluipui]

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!

 

[Dave Peterson]

Nope.

Conditional formatting applies to the entire contents of the cell.

 

[puiuluipui]

Ok, thanks very much!
Have a good day!

"Dave Peterson" a scris: