Edit: Split from [Solved] Highlight duplicates. That topic is marked solved. I created your own topic for you. -- MrProgrammer, forum moderator |
I am trying to do something similar but use a single "search" cell. Using P5 to search for duplicate numbers in column D.
Highlighting the cells D3:D203. Also I have tried simply highlighting P5 and typing in the formula.
So clicking "Format"> "Conditional Formatting" Selecting "Formula is" and typing AND($P5<>"";COUNTIF($D$3:$D$202)) (setting the style to highlight red. This doesn't seem to work. Am I doing something wrong?