'How to conditionally format cells in Excel by group?
I have a spreadsheet of identification numbers, and various results for each. I used a couple formula to see if the subject passed or failed any of a set of criteria, and now I need to go back through and see which ones can be removed from the list. Anyone that has all "Pass" in the four tests needs to get removed and put into a separate sheet in the workbook. But I'm not sure how to do that without going through and filtering the Identification column, looking at all the values, and then manually transferring them. I'm adding in some sample data to make it more obvious. In this case, I would need to move all values for "12345", "51000", and "24567" to Sheet2 based on the fact that all four of their test results are "Pass".
Other important data, cells in columns B:E have formula that output "Pass" based on other columns.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|