Selected Cell Colour

[John T. Riordan]

I find it difficult to distinguish the current selected
cell position. Is there a way to change the colour or
border to see more clearly on screen the current cell
location?

Thanks in advance,
John T. Riordan
Trett Consulting B.V.
+31-118-420-300

 

[xlbo]

Only via code. Right click on the sheet tab and choose "View Code
Choose Worksheet from the left drop dow

paste this into the empty selection change sub that is automatically generated

Cells.Interior.ColorIndex = xlNon
Target.Interior.ColorIndex =

This will set the background colour of the cell to yello

To find out the colorindex's available, run this

For i = 1 to 5
cells(i,1).interior.colorindex =
next i

 

[John T. Riordan]

Unfortunately this solution causes the selection range to
change evertime a new cell is selected so the paste
functionality is not operable.

Thanks anyway,
John T. Riordan

 

[Andy B]

John

You could try Chip's rowliner macro:

http://www.cpearson.com/excel/RowLiner.htm

Andy.