Conditional formatting; format the text sentence in parentheses in cells

[ahmetcomert]

Hi,

I have a file 7000 rows which contain text. There's more than one sentence in the cell.

I would like to format text in a cell like; All sentences Bold, except in parentheses. Sentences in parenthses will be Italic-not bold.

How can I formulate this issue and apply all rows? Please help

For example;

(text text) text text text, ( text ) text text text.

text (text) text text ( tex text text) text (text).


King regards.

https://www.mrexcel.com/forum/excel-...ml#post5201666 --Cross-post link added by Moderator