On Sat, 25 Oct 2008 14:28:53 -0500, "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

You will only be able to do this if the word you want to have boldfaced is
either the ONLY word in the cell, or, if it is part of a string, the string is
entered directly, and not as the result of a formula.

If the word is the result of a formula, and is also part of a multiword string,
it can still be bolded, but the original formula will have to be replaced by
the text string.

If these restrictions are satisfactory, please post back with more info as to
the characteristics of the cells containing this word.
--ron