|
|
#5
02-05-2025, 04:39 PM
|
|||
|
|||
Batman1
I tested both of your proposed solutions. They both work with "durations defined as 1 or more e.g., 1-BR, 1.5-US, 2.5-AP etc. However, if duration is < 1 e.g., .25-BR, .5-US or .75-UK they are not being detected by your RegEx expression. Unable to find expression to work in all cases. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula or VBA code to format certain cells based on the cell value | Seeker2025 | Excel | 1 | 02-03-2025 01:14 AM |
| Apply a formula based on whether a cell is blank or has a date | NLJ | Excel | 4 | 09-17-2021 06:02 AM |
 VBA Code apply draft
|
lodi123 | Word VBA | 1 | 02-21-2017 04:55 AM |
| Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
| Is it possible to have a style apply two formats based upon text? | DMcCollum | Word | 3 | 05-02-2015 06:29 PM |
Windows 10 
Office 2019
Threaded Mode