Home>Blogs>Excel Tips and Tricks>Highlight the Consecutive Duplicates in Excel

# Highlight the Consecutive Duplicates in Excel

In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance Sheet.

Let’s say we have month wise sales wherein we have month name duplicate. We want to highlight the consecutive duplicate month as given in below image

Below are the steps to put the Conditional Formatting to highlight the consecutive duplicate month-

• Select the Range (“A2:A30”)
• Go to Home >> Conditional Formatting >> New Rule or Press Alt+D+O+N
• Select “Use a formula to determine which cells to format”
• Put the formula “=OR(A2=A1,A2=A3)”  in the box.
• Click on Format button and select some background color.
• Click on OK.

Let’s say we have a Attendance Sheet wherein we need to highlight the Consecutive Weekly Off (WO) like given in below image –

Below are the steps to put the Conditional Formatting to highlight the Consecutive Weekly Off (WO) –

• Select the Range (“B2:AF11”)
• Go to Home >> Conditional Formatting >> New Rule or Press Alt+D+O+N
• Select “Use a formula to determine which cells to format”
• Put the formula “=AND(OR(B2=A2,B2=C2),B2=”WO”)”  in the box.
• Click on Format button and select some background color.
• Click on OK.

### Watch the step by step video tutorial:

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com