ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/228631-conditional-formatting.html)

puiuluipui

Conditional formatting

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

Conditional formatting

Nope.

Conditional formatting applies to the entire contents of the cell.

puiuluipui wrote:

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

puiuluipui

Conditional formatting

Ok, thanks very much!
Have a good day!

"Dave Peterson" a scris:

Nope.

Conditional formatting applies to the entire contents of the cell.

puiuluipui wrote:

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

All times are GMT +1. The time now is 12:17 AM.