Change background color of active cell

G

Guest

How do I change the color of the currently active cell and have it change
each time a new cell is selected?

Bruce
 
J

JohnDing

in subroutine "Workbook_SheetSelectionChange", place
following code:

ActiveCell.Interior.ColorIndex = 40
ActiveWorkbook.Colors(40) = RGB(192, 192, 192)

Use different RGB value to get colors you favorate...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Format of Active Cell 15
Excel Highlight active cell with font color? 3
GridLines Inadvertantly Goes Away with Macro 3
Changing cursor outline color of active cell 3
Pick a color from the default palette 2
Remove Hyperlinks Without Changing background shading 14
Note related background color of a cell 4
Cell Background Color Change --> Change Event 5

Top