Hi there,

Please could someone tell me how to highlight duplicate values in a column, but without highlighting the blank cells? There are many of these, so are showing up as duplicates. The column has 5000 or so lines of data and I am only interested in actual duplicate values.

Thanks!

Abi