I have a VLookup formula to another worksheet, but I need the bold text of
the referenced cells to show up as bold in the formula cell.

I understand you can do that with Conditional formating if the data is in
the same worksheet, but my data is in a different worksheet and it gives me
an error.