text: O Caçador has apoint, but it will work for the 50 rows only\nchange the references in that formula of $A$50 into $A50.\nThis will causes COUNTIF to enter all cells from A1 to the cell above me.\n\nOR\nYou can use my way (Which is also based on COUNTIF function)\nI used to add a column Column B) with this formula\n=COUNTIF( A4, $A$1:A4)\nand change its Conditional Formatting into Red when is more than zero.\nIn this example, the cell will be colored in Red when you entered a value that is saved above, no matter where you copy and paste it.\n\nEnjoy my profile, I am the VBAXLMan