Highlighting a whole row.
Hi,
Am Sat, 8 Jun 2013 21:41:32 +0100 schrieb lostgrave2001:
Hello sorry for the late replay, im using excel 2003 it will not allow
me to use a new rule. do you know of another way to do this?
in xl2003 try:
Format = Conditional Formatting Formula
If you can't add another conditional formatting you have to use VBA.
Sub CF()
Dim LRow As Long
Dim rngC As Range
LRow = Cells(Rows.Count, "E").End(xlUp).Row
For Each rngC In Range("E1:E" & LRow)
If rngC = 10000 Then
Range(Cells(rngC.Row, 1), Cells(rngC.Row, 5)) _
.Interior.ColorIndex = 6
End If
Next
End Sub
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|