VikingLink
New Member
- Joined
- Jun 18, 2022
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
Is there a way to highlight a 'check' cell outside of a range if there are one or multiple duplicate values within the range?
In the image below I want A1 and B1 to be highlighted whenever there are duplicate names.
To highlight the duplicates themselves, I'm using =COUNTIFS($A$2:$A$200,$A2,$B$2:$B$200,$B2)>1 in the conditional formatting applied to =$A$2:$B$200. But I can't get the top row to be highlighted if there is at least one duplicate.
In the image below I want A1 and B1 to be highlighted whenever there are duplicate names.
To highlight the duplicates themselves, I'm using =COUNTIFS($A$2:$A$200,$A2,$B$2:$B$200,$B2)>1 in the conditional formatting applied to =$A$2:$B$200. But I can't get the top row to be highlighted if there is at least one duplicate.