Reduplicate Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub mukerrer() For a = 1 To [a65536].End(xlUp).Row If WorksheetFunction.CountIf(Columns(1), Cells(a, 1)) > 1 Then Cells(a, 1).Interior.ColorIndex = 3 Next End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 reduplicate 2 deletes duplicate records (duplicate records) 3 excel operators hk 4 exit procedure 5 Zoom in / out or reduce the active sheet / page to a certain size 6 book window 2 size reduction 7 macro example of continuous flash 8 continuous flash example in excel 9 self-closing book at 10 sec 10 Blinking effect when you type x in cell a1 11 Specify row height and column width in cm 12 add buttons to an existing menu bar 13 self-closing book perfect in 10 seconds 14 add menu to file edit menu 15 endpoint in encryption 16 wmi windows 17 Find and select the remaining cell in the value between 2 selected numbers 18 macros box and macros appear 19 Insert and run the antidote procedure in the following link. 20 Application.OnTime