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