Highlighting a whole row.

[lostgrave2001]

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

Any help is always appreciated.

Kind regards

C

 

[Claus Busch]

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 E15 => Conditional Formatting => New Rule => Use a formula to
determine which cells to format => formula:
=$E5>9999.99


Regards
Claus Busch

 

[lostgrave2001]

Hello sorry for the late replay, im using excel 2003 it will not allo
me to use a new rule. do you know of another way to do this?


Thank you

 

[Claus Busch]

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

 

[Claus Busch]

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