Formatting multiple occurences of words.

[The Tamer]

Hi yall (how's my American coming along?),

I'm hoping to find occurences of the word "Siebel" in a spreadsheet and change the font to bold and blue. I also need to find the Occurences of " SAP" and change to bold and red. Does anyone know of any code that will help me do this, as I have 3,000 or so records to plough through. Problem is, only those words should be changed, even though a cell will contain these words anywhere in a given sentence.

Thanks in Advance

Regards

Damo

[Jacob Hilderbrand]

Try this.

• Select all your cells

• Format | conditional Formatting

• Formula Is

=NOT(ISERR(FIND("Siebel",A1,1)))

• Format as desired

• Rinse

• Repeat

[The Tamer]

FAB

[Jacob Hilderbrand]

Glad to help.

Take Care

[The Tamer]

You forgot "spin"!

Try this.

• Select all your cells

• Format | conditional Formatting

• Formula Is

• =NOT(ISERR(FIND("Siebel",A1,1)))

• Format as desired

• Rinse

• Repeat

[Jacob Hilderbrand]

You spin around when you wash your hair.

What happens if you get dizzy and fall out of the shower?

[The Tamer]

Eek! falling out of the shower!

I fainted once, climbing out of the tub. Was spotted on the floor by my lodger.