Is there a formula to highlight duplicates in Excel in the Same Column with a Different Color every other duplicate item/number? Example, I have a group of NIINs/numbers in a column, I want to have a different color every of other number i.e. 1st duplicate color red, next duplicate numbers yellow, next group of duplicate numbers red, then next yellow within the same column red then yellow every other duplicate number.