CODEWITHSUNDEEP
excelvba
jack
jack

Reputation: 1

Using VBA for Excel i want to make the text bold

I want a macro to find all the words written a column in another excel & make them bold.

For EX: I have Words like new, grow, etc written in a column B of Excel an the macro has to Find theses words individually in another excel & make them bold and change the Background of the cell to Red Color.

Thanks in Advance.

Upvotes: 0

Views: 965

Answers (1)

Joubarc
Joubarc

Reputation: 1216

You may want to have a look into conditionnal formatting.

Assume for example you have the values you want to look for in column B, and you want to highlight all values in a range, say, D4:F15.

Select the range D4:F15, make a new formatting rule and choose "Use a formula to determine which cells to format". Enter =ISNUMBER(MATCH(D4;$B:$B)) as formula, and make the format as you wish. Note that D4 in the formula has to be the first cell of the range.

If you don't need more than that, the benefit is that you don't need a macro at all, and the formatting can be done in real time too.

Upvotes: 4

Related Questions