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
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