Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |