Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Exact Issue
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Exact Issue
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Milrok" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match, Exact? NA error | Excel Discussion (Misc queries) | |||
Match - Exact - Lookup? | Excel Worksheet Functions | |||
Match name not exact | Excel Worksheet Functions | |||
Getting an exact match | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |