Conditional Formatting

Hi Dan,

Here is the process which you requested

Highlight column of your choice --> Conditional Formatting --> Highlight cell rules --> Duplicate values --> Choose colour of your choice --> Ok --> Conditional Formatting --> Manage Rules --> Highlight full range --> Use a formula to determine which cells to format --> Put in this formula
=COUNTIF(highlight the first column),first cell in that column> 1
--> Ok

For example =COUNTIF($A$3:$A$13,$A3)>1

Regards

Tony