Hey everyone, I'm having an issue with conditional formatting. I am using this formula, and it works great, only problem is blank cells are formatted as well. Any help would be appreciated...I'm basically having duplicates highlighted based off of another worksheet.
=SUMPRODUCT(--(G1=Sheet2!$U$1:$U$41))
=SUMPRODUCT(--(G1=Sheet2!$U$1:$U$41))