Hi,

You can do this with VBA or manually, but not a spreadsheet function. And a
formula can not be formatted by character only the entire thing.

--
Thanks,
Shane Devenshire


"Artis Tiedemann" wrote:

I want to write a formula that will locate a word everywhere it appears in a
worksheet and boldface it. I know that I can use 'find' and then boldface
to accomplish this but I have a extremely large worksheet and would like to
speed up the process. My knowledge of Excel is not advanced enough to even
know where to begin.

Is there a way to do this?

Artis