format a string as bold

Looks like a nice community here. Hopefully somebody can lend me a hand on this.

Here is my goal:
I have a column with 3 tri-state text strings in it. Example: |1 2 3| or |1 2 3| or | 2 3|
So, 1, 2, and 3 all have the option of being null(not present), normal, and bold.

I have set the inital value of each as normal text, without any formatting.

I have tried the following code, without much success. I keep getting Invalid Qualifier errors.

Please Login or Register  to view this content.

I am getting the error highlighting AR_Text. in "With AR_Text.Characters....."

If any further info is needed, feel free to ask.

I made the following changes, and got halfway there...

Please Login or Register  to view this content.

Now, it shows correctly in my column, but the bold tags are there too.

Not sure exactly what you're trying to do, but you can try something like this.
You can do it without the WITH statement, but I have included it (commented out) in case you want it.
It assumes your data ("AR ", "G" and " F") are in cells A1:A3.
It just changes everything to bold, so you would have to work out what you want to do from there.

Please Login or Register  to view this content.

Got it

Please Login or Register  to view this content.

Works perfect!

I just needed a sounding board... Thanks.

Nice work.