Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 10
Question 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,872
Default 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
  #3   Report Post  
Junior Member
 
Posts: 10
Smile

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

Quote:
Originally Posted by Claus Busch View Post
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
  #4   Report Post  
Posted to microsoft.public.excel.newusers
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
  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,872
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
highlighting Jade Excel Discussion (Misc queries) 1 July 2nd 08 04:54 PM
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. Jamie Furlong Excel Discussion (Misc queries) 6 August 28th 05 09:27 PM
Highlighting gwenturpin Excel Discussion (Misc queries) 23 June 16th 05 04:28 PM
Again about Row Highlighting [HELP] Alex[_26_] Excel Programming 2 October 13th 04 09:36 AM
Highlighting Lisa[_8_] Excel Programming 1 September 25th 03 02:31 PM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"