Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlight Row
I want to be able to highlight the whole row if any cell in a worksheet is
selected. Is this possible. If so how would you do it. Excel is not my field so I need a simple solution. |
#2
|
|||
|
|||
Pogo, Hit CTRL and Spacebar to highlight a column and Shift and spacebar to
Highlight a row. Hope this helps. _jim "Pogo" wrote: I want to be able to highlight the whole row if any cell in a worksheet is selected. Is this possible. If so how would you do it. Excel is not my field so I need a simple solution. |
#3
|
|||
|
|||
This is what I use
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.FormatConditions.Delete With Target.EntireRow .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With End With .FormatConditions(1).Interior.ColorIndex = 20 End With End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "Pogo" wrote in message ... I want to be able to highlight the whole row if any cell in a worksheet is selected. Is this possible. If so how would you do it. Excel is not my field so I need a simple solution. |
#4
|
|||
|
|||
Thanks. That's just what I need.
"Bob Phillips" wrote in message ... This is what I use Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.FormatConditions.Delete With Target.EntireRow .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With End With .FormatConditions(1).Interior.ColorIndex = 20 End With End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "Pogo" wrote in message ... I want to be able to highlight the whole row if any cell in a worksheet is selected. Is this possible. If so how would you do it. Excel is not my field so I need a simple solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight lowest number | Excel Discussion (Misc queries) | |||
Highlight Data | Excel Discussion (Misc queries) | |||
HELP ME !! PLEASE!! How do I highlight a cell when it reaches a va | Excel Worksheet Functions | |||
Highlight Active Cell | Excel Discussion (Misc queries) | |||
Auto Highlight a Row | Excel Worksheet Functions |