Yes, you can use the 'Conditional Formatting' option to create a formula that will automatically highlight or remove duplicates as they are entered into the worksheet. This can be done by going to the 'New Rule' option and selecting 'Use a formula to determine which cells to format'.