Nothing built into excel that would allow you to do just change the format of a
single word in a cell that contains multiple words.

MSWord can change the formatting of a single word, though.

Lorinda wrote:

Yeah, that's been my experience all afternoon...Is there anything to using
Find/Replace with Formatting to do this? In Excel or Word?

"Dave Peterson" wrote:

Conditional formatting applies to the entire cell--not just a word within a
string of words.



Lorinda wrote:

A spreadsheet full of cells with lots of text, no other formula/format. Can I
use conditional formatting to color any word that is like 'fraud' red and
leave the rest alone?

--

Dave Peterson


--

Dave Peterson