Match Identifying Problem

[DORAMIUS]

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.

 

[erik.van.geit]

Hello, DORAMIUS,

would this work for you ?
=AND(COUNTIF($G$1:G1,G1)>1,G1<>"******")


kind regards,
Erik

 

[DORAMIUS]

Dammit. I keep forgetting <> means NOT EQUAL.

You Da Man Erik. Thanks.