PDA

View Full Version : [SOLVED] Formatting multiple occurences of words.



The Tamer
02-17-2005, 05:02 AM
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
02-17-2005, 05:08 AM
Try this.

Select all your cells



Format | conditional Formatting



Formula Is




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



Format as desired



Rinse



Repeat

The Tamer
02-17-2005, 05:18 AM
FAB

Jacob Hilderbrand
02-17-2005, 05:34 AM
Glad to help. :beerchug:

Take Care

The Tamer
02-17-2005, 05:47 AM
You forgot "spin"! :devil:


Try this.

Select all your cells


Format | conditional Formatting


Formula Is


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


Format as desired


Rinse


Repeat

Jacob Hilderbrand
02-17-2005, 05:49 AM
You spin around when you wash your hair. :eek:

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

The Tamer
02-17-2005, 05:54 AM
Eek! falling out of the shower!

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