Search and change font color to Red and bold it

C

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Change the font color based on the value of the cell 9
Using VBA coding to count color Occurrences 4
Match table shading (color) to Visio color/Transparency 1
Remove Hyperlinks Without Changing background shading 14
WORD VBA Search and switch to advanced ... 1
Locate and change font color 1
search for special character in different fonts 0

Top