Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Active cell border

Is there a way I can change the colour of the border of the active cell. It is hard to notice
if all the cells have borders.?
Active cell meaning the cell where mouse is clicked on.
Thanks
Ian
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

See this link for possible solutions.  Though it is not just border color, but cell color the code could be modified I'm sure.

http://www.atlaspm.com/toms-tutorials-for-excel/toms-tips-for-excel-color-the-active-cell-row-or-column/

I added the "Cell Only" code to the attached spreadsheet so you can see how it might work.  Two issues (I think): the code needs to be added to any tab you want the coloring of active cell to occur, and the workbook needs to be saved as a macro workbook.
EE.xlsm
Avatar of Ian Bell

ASKER

Hi Tom,
Thanks for the link.
Your idea re cell colour was better. However when I copied the code and opened the sheet the
already coloured cells returned to white colour.
I wondered if you could possibly code your attached sheet. I've coloured the cells
and would like the active cell to be any colour, maybe white would be best.
What do you think ?
Thanks
Ian
EE.xlsm
Are you saying you already have colored cells in your spreadsheet you want to leave colored?  The code I sent you (and it isn't my code) first changes all cell colors to white, then highlights the active cell in the blue/green color.
Yes, they are all coloured and would like to keep them this way. The cells have borders.
I would like the active cell to somehow stand out that is why I wanted a border change to white or the active cell background to change to white.
At the moment the active cell is hard to identify as I use black borders.
Another idea is it possible to have a thick black border around the active cell ?
Thanks
Ian
ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Tom,
It works well :)
Ian
Glad to hear it.