Highlight duplicate rows without helper column

I am using:

=COUNTIF($D$2:$D$14,D2)>1

to give me TRUE / FALSE, where column D is a helper column consisting of columns A, B and C concatenated.

Is there any way to use a single formula for CF without a helper column?

Hi,

Yes, you're using XL 2007 so you can use COUNTIFS() directly in the conditional formatting.

=COUNTIFS($A$2:$A$14,$A2,$B$2:$B$14,$B2,$C$2:$C$14,$C2)>1

Try this, note the anchors ($)
Formula is:=

Please Login or Register  to view this content.

Applies To:=

Please Login or Register  to view this content.

Hi,

In earlier versions I take it you would use SUMPRODUCT?

COUNTIFS wasn't available pre 2007 so, yes, SUMPRODUCT would be an alternative option.