I am looking for formula for a macro which will automatically bold specific words. The data is in column A. I have various words I would like to be bold. Any help is greatly appreciated.
Sub Macro1()
Dim r As Range
For Each r In Range("A1:A10") 'add your own range
If r.Value = "Your word" Or r.Value = "next word" Then 'add your own words here
r.Font.Bold = True
End If
Next
End Sub
Will the words be the only thing in the cell or are you looking to bold specific words within the cell range where each cell has more than the word or words you are looking for?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.