Change background color of active cell

[Guest]

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

Bruce

 

[Norman Jones]

Hi Bruce,

See Chip Pearson's highlight active cell page at:

http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

 

[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...