Hi all,
I've found a bunch of info on the net for mac users to change the 'cursor' or 'cell outline' color, but nothing for windows users. Can this be done? If so how do I do this little trick?
Any help, as always, much appreciated.
Lock-e73![]()
Hi all,
I've found a bunch of info on the net for mac users to change the 'cursor' or 'cell outline' color, but nothing for windows users. Can this be done? If so how do I do this little trick?
Any help, as always, much appreciated.
Lock-e73![]()
Hello,
U can change Grindlines colour as follows
From Menu select 'Tools' -> 'Options' -> 'View' -> 'Windows option' -> then select color as per your choice.
You can also change the border color of any cell or group of cells as needed. Select cell(s), right-click selection and choose 'Format Cells...' and go to the Border tab. Choose a color and which edges you want to color.
Hi folks,
Thanks for the answers to my query, but I was actually attemting to change the color of the 'cursor' if you like. The outline of a cell when selected ... not the cell itself or the grid. It is currently a black outline or 'cursor' and I was wondering if you could make it green lets say? I realise you can change the grid line colors and thickness but can you change the 'cursor' (don't know how else to describe it ... not sure if I'm being clear!?)
Thanks again in advance for any help
Lock-e73![]()
Good evening lock-e73
You can do this type of thing, but only by using VBA (or macros) - there is no built in Excel setting to control this.
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Chip Pearson discusses this subject here :
http://www.cpearson.com/excel/excelM...ightActiveCell
and provides an add-in for you to download here :
http://www.cpearson.com/excel/RowLiner.htm
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks