Dan has attended:
Excel Intermediate course
Conditional Formatting
How to highlight rows based on one cell of data.
RE: 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