Forum Discussion
Highlight active cell
Does anybody know how to highlight the active cell selection in Excel. I have a large table of data in which recurring values are often searched for and whilst the search is accurate enough, it's sti...
I believe you could add a macro to your worksheet containing the table to highlight the selected cell.
I would also suggest adding a cell to your worksheet, which I named "EnableHighlight," so you could turn it on/off without having to edit the vba code every time.
I attached an example file you can play with. If you right click on the worksheet tab and select "view code," then you will see the macro.
If you do add the macro to your own workbook, then be sure to save it as .xlsm (macro enabled) and not a .xlsx or the macro will get stripped out.