View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rhonda[_3_] Rhonda[_3_] is offline
external usenet poster
 
Posts: 17
Default Forgot to paste!

ooops!

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Dim strRow As String
Cells.FormatConditions.Delete


With Target.EntireRow
strRow = .Address
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:="=COUNTA(" & strRow & ")0"

.FormatConditions(1).Font.Bold = True
.FormatConditions(1).Interior.ColorIndex = 15
End With
End Sub