change color of every occurene of FOX

[jennifer]

Hi, I would like to search my work sheet for every occurence of the word FOX and bold it and make it Red.... Can I do that?

 

[Dave R.]

Yes, press CTRL H

type fox into the find what box
type fox into the replace with box

In my version of excel there's an OPTIONS button.click it. select format, go
to font, select bold and color red.

then go back a bit and press replace all.

Hi, I would like to search my work sheet for every occurence of the word

FOX and bold it and make it Red.... Can I do that?

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format' for this