![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#4
|
|||
|
|||
|
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:
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 |
| 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 |