Sub to make text bold

[ksnapp]

Hello, I have looked at several examples on here and the web and can't
figure out how to make a sub that will make text in a row bold based on
certain words in column being there.

What I'm hopin to do is select a column in my worksheet and run a sub
that will make all the information in a row bold in the seleceted cell
contains Total Transactions.

Any help or examples of close code are appreciated.

 

[Bob Phillips]

For Each cell In Selection
If cellValue = "Total Transactions" Then
cell.Font.Bold = True
End If
Next cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)