Search and change font color to Red and bold it

[CAM]

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

 

[Nigel]

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.