Thanks for your reply Steve=True. Yeah, I know how to do that to find duplicates within a single column using conditional formating, but I need to know if there are duplicates say in Column A and Column F. That's what I don't know how to do.Have you tried conditional formatting? I am in 2007, but thought that was an easy option in 2003
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | List 1 | List 2 | ||||||
2 | a | b | ||||||
3 | b | y | ||||||
4 | c | f | ||||||
5 | d | x | ||||||
6 | e | a | ||||||
7 | f | z | ||||||
8 | g | h | ||||||
9 | ||||||||
CF Duplicates |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2 | 1. / Formula is =COUNTIF($F$2:$F$100,A2) | Abc | ||
F2 | 1. / Formula is =COUNTIF($A$2:$A$100,F2) | Abc |