Bold-face a sub-string

**andrew06** · 06-25-2013, 05:10 AM

Hello all,

From what I gathered after researching, there is not a formula which you can apply conditional formatting to a cell's values, partially. I am working on a spreadsheet that contains a lot of numbers with relevant information in parenthesis. Sometimes, there will be multiple numbers or IDs in the same cell. I was wondering if anyone knows of a VBA formula that basically does this: bold-face all values not in parenthesis in a range of cells. I'd appreciate any help you guys can lend!

Example of what I am looking for:
Cell A1 values: "12345 (Kang, 4/4/57)"
Cell A2 values: "12355 (Andrew, 6/26/86) 99999 (Young, 5/29/58)"

Thanks,
Andrew

**jindon** · 06-25-2013, 05:31 AM

Try

Please Login or Register  to view this content.

**Norie** · 06-25-2013, 05:35 AM

Andrew

This works with your sample data.

Please Login or Register  to view this content.

To use it open the VBE (ALT+F11), goto Insert>Module and paste the code in the newly created module.

Then close the VBA (ALT+Q), goto the Developer tab. click Macros, select BoldIDs and then click run.

**andrew06** · 06-25-2013, 06:26 AM

Thanks, guys, for your suggestions/help! I left the office several minutes ago, and I will test your codes as soon as I return. For the same workbook, I employ the UDF, lookup_concat, which segways into my next question. Do I need to keep the lookup_concat function and your conditional formatting coding in two separate modules, or am I supposed to add your suggestion(s) to the module that already contains the lookup_concat? Sorry, I am brand new to VBA.

By the way, if it makes any difference, after I get the results I need using the lookup_concat function, I get rid of the formula in the cells, by copying and pasting only the values to avoid using too many resources. Yes, my workbook contains extreme amounts of data.

**Norie** · 06-25-2013, 06:33 AM

You can have the code I posted in the same module as the concat function.

It will only work on values, not formulas so you would run it after you've replaced the formulas with values.