View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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