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
|