Somehow I need to take my formula into code
and BOLD the cells J$1, K$1, L$1, M$1, N$1.

You cannot bold parts of text output by a formula... its either bold all the
displayed text or not. You can only bold parts of the text in a cell if that
text is a text constant.

Rick Rothstein (MVP - Excel)