Highlighting a whole row.
Hi,
Am Sun, 9 Jun 2013 12:31:05 +0200 schrieb Claus Busch:
If you can't add another conditional formatting you have to use VBA.
or do it while entering data to your table. Paste the code into the
code module of the worksheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("E")) Is Nothing _
Or Target.Count 1 Then Exit Sub
With Target
If .Value = 10000 Then
Range(Cells(.Row, 1), Cells(.Row, 5)) _
.Interior.ColorIndex = 6
End If
End With
End Sub
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|