Match Exact Issue

  • Thread starter Thread starter Milrok
  • Start date Start date
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
 
One play ..

Assuming data in cols A to F, from row1 down,
with 5 response cols in cols B to F

Select cols A to F (A1 active)
Click Format > Conditional Formatting
Under Condition 1, make the settings as
Formula is: =COUNTIF($B1:$F1,$B1)=5
Click Format > Patterns tab > Red? > OK
Click OK

Note that the "5" in the formula is the number of response cols
 
Back
Top