Use conditional formatting, in Excel 2007 it is a breeze.

Select all cell that you wish to apply the CF rule to then

From the Home Ribbon, choose 'Conditional Formatting', select 'Highlight
Cell Rules' then click 'Text that contains', enter you text e.g Tony, use
the with option to select custom format and enter you bold/red option.

Need the code? then turn on macro recorder before applying the above.
--

Regards,
Nigel




"CAM" wrote in message
...
Hello,

I am using Excel 2007 and I want to change certain cells font color to Red
and bold it within a workbook when I search for a particular string within
a cell - example "Tony" all the cells that have "Tony" will be bold and
font color will change to Red for the entire workbook. How do I code
that? Thanks in advance