M
Milrok
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
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