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