I'm currently using formula =COUNTIF($G$1:G1,G1)>1 in column G to identify duplicate numbers. However, sometimes a reference number is not required, so ****** is input instead as it cannot be blank for business reasons. my formula identifies it as a duplicate and it's not supposed to be so it shows on a report incorrectly. What formula can I add to remove the cell highlighting for just ****** without it conflicting with my current formula? I've attempted a number of differet ways, but they seem to not work because of the above listed formula, or they cancel the ability of the first formula.