Hello!

I am concatenating text (="DESC: "&M10&CHAR(10)&"QTY: "&M11, etc.) , but when I do that, Excel wants me to format the whole cell instead of just parts of the text.

Here is what I was thinking as a workaround:

Sheet = "Labels"
LookForList = ("SALES ORDER:","SUPPLIER:","DESC:", "HT, S/N, ETC.:", "QTY:")
For every cell in Range (A1:C11)
If cell.value has text in LookForList, then bold that text.
Next
Obviously, my code is horrible but hopefully you can see what I am looking for. I also would need to know which event that code goes in.

Any help appreciated!

Thanks!

Lost