I have a database in Excel, 10 columns. In col 5, if input is "client", I
want that whole row to change to Bold Font.
How to do this?

By using Conditional Formatting on the Format menu.

Debra Dalgleish explains more he

http://www.contextures.com/xlCondFormat01.html

Hope this helps.

Pete

On Oct 5, 12:50 pm, "Centrol" wrote:
I have a database in Excel, 10 columns. In col 5, if input is "client", I
want that whole row to change to Bold Font.
How to do this?

Hi,

Your a bit low on detail so I have assumed Column 5 of your databse is
column E so change to suit. Right click the worksheet, view code and paste
this in:-

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E1:E100")) Is Nothing Then ' alter to suit
If Target.Value = "Client" Then
Target.EntireRow.Select
Selection.Font.Bold = True
Target.Select
End If
End If
End Sub


Mike

"Centrol" wrote:

I have a database in Excel, 10 columns. In col 5, if input is "client", I
want that whole row to change to Bold Font.
How to do this?

Thanks Mike. The deciding column is D. So this is what I paste :

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D1:D100")) Is Nothing Then
If Target.Value = "Client" Then
Target.EntireRow.Select
Selection.Font.Bold = True
Target.Select
End If
End If
End Sub

Nothing happened. Plse tell me what have I missed? Thanks


"Mike H" wrote in message
...
Hi,

Your a bit low on detail so I have assumed Column 5 of your databse is
column E so change to suit. Right click the worksheet, view code and paste
this in:-

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E1:E100")) Is Nothing Then ' alter to suit
If Target.Value = "Client" Then
Target.EntireRow.Select
Selection.Font.Bold = True
Target.Select
End If
End If
End Sub


Mike

"Centrol" wrote:

I have a database in Excel, 10 columns. In col 5, if input is "client",
I
want that whole row to change to Bold Font.
How to do this?