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
|User Form VBA Data + Print Sections||39||114|
|Excel Score Formula||5||51|
|Create Excel formula on dynamic data||5||35|
|how to extract the last folder name with formula and UDF||5||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!