I am attaching excel workbook. after opening it you will see that in column A there are 162 records. In records you will notice that after some item numbers there is "Item" written. I want to use this word "Item" as separator of this records and highlights duplicate values which are begins after "Item" phase. In this attached reference sheet I have achieved result using condition formatting by selecting values between "Item" phase and then applied 'highlight duplicate values' But it is time consuming. Tthis data is for reference only. I have to dill will very vast data. So if you can provide me the formula which i can use in Conditional Formatting > New rule > Use a formula to determine which cells to format