John Carney
asked on
VBA code that formats a word (that word only) if it is present in each cell of a specified range
How do I write a code that says in effect: Look for the string "27D" inside each cell in a specidied range, and make that string Red Bold? This sample code is just to give you a better idea of what I'm looking for
Thanks,
John
Thanks,
John
Sub FormatText()
Dim str As String
'str = find "27D" within the cell and make it Red Bold
For Each cell In Range("B2:B200")
str.Font.ColorIndex = 3 'I know this is all wrong
str.Bold = True 'I know this is all wrong
Next
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried closing this 2 hours ago but I couldn't. Thanks again!
- John
- John
ASKER
I never would have gotten this except for your post, so thanks.
- John
Open in new window