Hi,

I am trying to highlight records in a spreadsheet where there are
differences in 5 columns. The spreadsheet is response to an RFP.
Consensus is required so, if there is one respondent with an answer
that isn't the same as the others I need to highlight this.

The spreadsheet would look like this:

Requirement Response 1 Response 2 Response
3 Response 4 Response 5

r1 5
5 5 5
5
r2 5
4 5 5
5
r3 4
4 4 4
4
r4 3
2 1 4
0


If the formula works r2 and r4 would be highlighted. r1 and r3 would
not.

Any help would be greatly appreciated.

Thanks,

Scot