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