Use A Macro To Highlight The Active Cell
June 14, 2021 - by Bill Jelen
Challenge: Microsoft changed the selection highlighting in Excel 2007. If you select 20 cells, Excel highlights those cells in super-ultra-light blue. Imagine if you had 5 gallons of white paint and dropped in one drop of blue paint. That paint would have more color than the new selection color in Excel 2007. You want to highlight the active cell so it’s easier to spot.
Solution: There is a cool event macro that can add a splash of color to the selection and draw crosshairs to help you locate the row and column where the active cell is located. In Figure 141, bright yellow highlight indicates the active cell in D16. Lighter yellow is used to mark column D and Row 16. As you move the cell pointer, the highlights change. Figure 142 shows the crosshairs pattern for B20.