Conditional Formatting of Rows. Too many duplicates!

[bjoanmark]

Hi All,

I'm trying to use Conditional Formatting to highlight and differnces in each row of three columns of data. So in the example below I would want to highlight from the first row 1, second row I want to highlight 2, thrid row 3 and 6, fourth row there would be nothing to highlight and so on.

I tried to use duplicate as a reverse function but when I've copied the cells down it highlights practically all the numbers as its looking at the whole set rather than individual rows.

Not quite sure what the formula would be just for a row?

Many thanks in advance

ABC
122
121
136
444
555
111
121

[Special-K]

Correction: You actually want to highlight row 7, not row 6, row 6 is 111 and you are highlighting a complete row when there is a difference on that row

Select the entire range

Conditional Formatting
New Rule
Use a formula to determine...

=COUNTIF($A1:$C1,$A1)<>3

Format as required

[bjoanmark]

Many thanks that did the job!