i have lots of data in column a and i want to check for duplicates. what code would i need to use so that everytime a duplicate is found it turns the cell red
i have lots of data in column a and i want to check for duplicates. what code would i need to use so that everytime a duplicate is found it turns the cell red
Will this work for you.
![]()
Please Login or Register to view this content.
Kind regards, Harry.
Use in Conditional formattin: =COUNTIF($A$1:$A$1000, $A1)>1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks