koala
08-11-2011, 03:08 AM
Hi forum,
I have a simple spreadsheet that has combinations of text and numbers. I want to change the font to Red & Bold on a certain word whereever it is found.
The spreadsheet changes often, and the word may be by itself, at the start / end or any part of a description.
I have attached a spreadsheet with a sample of the worksheet, and also a sample of how I need the final result to be. My poor attempt at the code is also there.
Any help is greatly appreciated.
Regards
Koala
I have a simple spreadsheet that has combinations of text and numbers. I want to change the font to Red & Bold on a certain word whereever it is found.
The spreadsheet changes often, and the word may be by itself, at the start / end or any part of a description.
I have attached a spreadsheet with a sample of the worksheet, and also a sample of how I need the final result to be. My poor attempt at the code is also there.
Any help is greatly appreciated.
Regards
Koala