![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
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 |
| Tags |
| microsoft word, vba change color, vba editor |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA Code to search for field codes with certain text before the Field code and to change style
|
welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
code to rewrite numbers
|
romanticbiro | Word VBA | 7 | 02-15-2014 03:04 PM |
| How to change the formatting of numbers without changing the numbers? | sullengirl | Word | 2 | 01-27-2014 03:06 PM |
| How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
| Extract Numbers from Zip Code | Karen615 | Excel | 3 | 09-21-2011 06:54 AM |