Forum Discussion
Highlight active cell
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.
JMB17 Many thanks this is great start.
If you are solely checking for duplicates, why not use conditional formatting to find and highlight in one easy step?
Select data range to be checked then, from the Home tab, select Conditional Formatting, from the drop-down choose Highlight Cells Rules and then Duplicate Values. Done!