![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
![]() |
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 |