Change cell border color when selecting cell

[mhawker]

Not to be confused with changing a cell's border color in general, is
there a way to change the color a cell's border becomes when clicking
on it? For instance, when I click on a cell on my iMac G5 using Excel
2004, the cell's border becomes light blue as a visual indication of
where I just clicked. For me, this is kind of hard to see. Is there a
way to change what color the cell becomes when clicking it?

The Mac's System Appearance settings don't seem to affect it.

Thanks,

Mike

 

[Jim Gordon MVP]

Hi,

If you are willing to make a macro that would accomplish this, there are
several ways of going about it.

You need to trigger an event (run the macro) when something happens
(such as double clicking or pressing a certain keyboard combination).

There is a list of the kinds of events that you can use to activate your
macro here:
http://support.microsoft.com/kb/151468/en-us

More information about macros is here:
http://www.mcgimpsey.com/excel/index.html#usingvba

If you reply to this thread with your comfort level with macros, folks
here will either get you started with macros or help you work out the
necessary macro to accomplish your task.

Don't be afraid of macros. They can do all kinds of things. Once you get
started with them you'll find they can be pretty tame most of the time.

-Jim

 

[JE McGimpsey]

Not to be confused with changing a cell's border color in general, is
there a way to change the color a cell's border becomes when clicking
on it? For instance, when I click on a cell on my iMac G5 using Excel
2004, the cell's border becomes light blue as a visual indication of
where I just clicked. For me, this is kind of hard to see. Is there a
way to change what color the cell becomes when clicking it?

The Mac's System Appearance settings don't seem to affect it.

XL loads the highlight setting on startup - close and reopen XL to see
the change in the System/Appearance setting.

You can also take a look at Chip Pearson's RowLiner add-in, which
provides a different solution:

http://cpearson.com/excel/rowliner.htm

It's written for WinXL, and the dialogs are a bit compressed, but last I
checked, it works fine for XLv.X and XL04.

 

[mhawker]

JE McGimpsey,

You're two for two! Changing the System Appearence's Highlight took
effect after I restarted Excel..... I'm surprised I didn't think of
that. One de-merit for me. It's too bad you can't change the
weight of the line when it highlights. This would be exactly what I
need.

Your suggestion for Row Liner is close enough to perfect that I'm using
it! FWIW- It downloaded and worked fine on my Mac and Excel 2004.
Very cool.

Thanks to you both!

 

[mhawker]

JE McGimpsey,

You're two for two! Changing the System Appearence's Highlight took
effect after I restarted Excel..... I'm surprised I didn't think of
that. One de-merit for me. It's too bad you can't change the
weight of the line when it highlights. This would be exactly what I
need.

Your suggestion for Row Liner is close enough to perfect that I'm using
it! FWIW- It downloaded and worked fine on my Mac and Excel 2004.
Very cool.

Thanks to you both!

 

[JE McGimpsey]

Your suggestion for Row Liner is close enough to perfect that I'm using
it! FWIW- It downloaded and worked fine on my Mac and Excel 2004.

Thanks for the update!