Format text font in parentheses Excel

August 5, 2019 at 08:04:49
Specs: Windows 10
I'm looking for a way to code/ format an excel document so that when text is placed in parentheses, the font color is automatically changed for that specific text e.g. (this text is now red). Also, including the parentheses.

See More: Format text font in parentheses Excel

Report •

August 5, 2019 at 14:32:11

Report •

August 5, 2019 at 18:36:12
Perhaps some examples of your text strings would help.

All text within parenthesis? (The house is blue)
Text with and without parentheses? The (house) is blue
Text with and without parentheses, multiple times? The (house) is (blue)

In addition, where is this text? Everywhere in the sheet? In one column or row?

The more specifics you provide, the better the chance that we can offer a solution that works without a lot of back and forth.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Report •
Related Solutions

Ask Question