Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell hililte
Is there a program I can insert that will hilite the cell I am working in at
any time? Thanks Rus |
#2
|
|||
|
|||
You may want to try Chip Pearson's utility:
http://www.cpearson.com/excel/RowLiner.htm Be aware that with this (and most macros), you lose the ability to do Edit|Undo. D wrote: Is there a program I can insert that will hilite the cell I am working in at any time? Thanks Rus -- Dave Peterson |
#3
|
|||
|
|||
Here is another, similar way
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 Bob Phillips "D" wrote in message ... Is there a program I can insert that will hilite the cell I am working in at any time? Thanks Rus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |