View Single Post
 
Old 07-16-2021, 04:57 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,161
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote