Hello everyone



I want to change the formating of only numbers between parenthesis using VBA code
like this

img_55.png

Additionally, some parenthesis contain numbers like these (5,12), (53-57), (123,136,156), (123-136,156)

keep in your mind, changing the formating of only numbers, not text nor parenthesis itself.

Thanks in advance

I would do this via two consecutive find/replaces. You can record these steps and tidy up the code to make it a macro.

Find: \([0-9\-,]{1,}\)
Replace with: leave box empty but set font format to red
Wildcards On

Find: [\(\)]
Replace with: leave box empty but set font format to auto or black
Wildcards On

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Wow Mr. Guessed
I thank you so much

Excuse me Mr. Guessed,
What if I want to change the formatting of everything inside the parenthesis
what I shall write in the Find
Also in the same idea (comma and dash among elements inside the parenthesis).

Lastly, how to make your answer a correct answer or solved question.

Thanks

To keep the parentheses, commas, and dashes black, do the following four find/replaces:

Find: ([\(])([0-9\-,]{1,})([\)])
Replace with: \1qq\2\3qq
Leave box empty but set font format to red
Wildcards On


Find: ([\(])(qq)
Replace with: \1
Leave box empty but set font format to auto or black
Wildcards On


Find: ([\)])(qq)
Replace with: \1
Leave box empty but set font format to auto or black
Wildcards On


Find: [,\-]
Set the font color to red
Replace with: Leave blank
Set the font color to black or auto
Wildcards On



NOTES:

• The "qq" is dummy text, to make sure that the only parentheses found/replaced are the ones surrounding your numbers. I am assuming that there's a possibility that you have other, red text that you do NOT want altered.

• You have to do this in four steps because, while you can search for multiple items in a string (by grouping them in parentheses), you cannot selectively apply formatting to only a portion of the string, i.e., you can't apply red to the numbers while leaving the parentheses black.

• If you do NOT have other colored text, then you can do all of the above more simply, as follows:

Find: [\(][0-9\-,]{1,}[\)]
Replace: Leave blank
Set font color to red
Wildcards On



Find: [\(\)\-,]
Set font color to red

Replace with: Leave blank
Set font color to black or auto
Wildcards On