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).

​

 

[6StringJazzer]

This cannot be done with conditional formatting. It can be done only with macros. Are you interested in that kind of solution? It's not a trivial bit of coding.

Your example does not match your description. Your example shows portions in parentheses that are bold.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ge...he-text-sentence-in-parentheses-in-cells.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[ahmetcomert]

This cannot be done with conditional formatting. It can be done only with macros. Are you interested in that kind of solution? It's not a trivial bit of coding.

Your example does not match your description. Your example shows portions in parentheses that are bold.

Sorry, your are right. True example is below;


(text) text text (text) text

text (text) text text (text)

How can I do it with macros?