Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I have an active cell highlight automatically
I am working in excel and having trouble seeing the active cell. I would
like to have the active cell highlighted. Is this possible? It would make it possible to find the active cell easier. |
#2
|
|||
|
|||
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete With Target .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) "lstuckey" wrote in message ... I am working in excel and having trouble seeing the active cell. I would like to have the active cell highlighted. Is this possible? It would make it possible to find the active cell easier. |
#3
|
|||
|
|||
Try this site
http://office.microsoft.com/en- us/assistance/HA011366231033.aspx -----Original Message----- I am working in excel and having trouble seeing the active cell. I would like to have the active cell highlighted. Is this possible? It would make it possible to find the active cell easier. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) | |||
Unable to set the active cell from VBA | New Users to Excel | |||
Highlight Active Cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Load active cell data via a function | Excel Worksheet Functions |