View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cond Format any word with 'fraud' in it

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