Sub to make text bold
 

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.


---
Message posted from http://www.ExcelForum.com/

Sub to make text bold
 

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)

"ksnapp " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/