If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell indicator
Can you change the color of the black rectangle the indicates what cell you
are in? I have someone who is making the cells in their table black so when they use the arrow key to move from one cell to another its white and they have a hard time telling what cell they are in. They don't want to change the black border of the cells in the table. Can they change the cell indicator to red or pink something that shows up better. |
#2
|
|||
|
|||
Cell indicator
Try this alternative approach
'---------------------------------------------------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) '---------------------------------------------------------------- Cells.FormatConditions.Delete With Target With .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 .Interior.ColorIndex = 20 End With End With With .EntireColumn .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With .Interior.ColorIndex = 20 End With End With .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" .FormatConditions(1).Interior.ColorIndex = 36 End With End Sub -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "D''Wanna" wrote in message ... Can you change the color of the black rectangle the indicates what cell you are in? I have someone who is making the cells in their table black so when they use the arrow key to move from one cell to another its white and they have a hard time telling what cell they are in. They don't want to change the black border of the cells in the table. Can they change the cell indicator to red or pink something that shows up better. |
Thread Tools | |
Display Modes | |
|
|