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. |
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. |
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. . |
All times are GMT +1. The time now is 02:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com