Highlighting a whole row.
 

hello
I am trying to highlight an entire row (e1-e5) if E5 if over £9999.99. i need the whole row to be highlighted in red is this possible?? im using Excel 2003 to attempt this.

Any help is always appreciated.

Kind regards

CR

Highlighting a whole row.
 

Hi,

Am Mon, 20 May 2013 00:29:51 +0100 schrieb lostgrave2001:

I am trying to highlight an entire row (e1-e5) if E5 if over £9999.99. i
need the whole row to be highlighted in red is this possible?? im using
Excel 2003 to attempt this.

select E1:D5 = Conditional Formatting = New Rule = Use a formula to
determine which cells to format = formula:
=$E59999.99


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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?


Thank you

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

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