That is a great version, does very close to what I'm trying to do. But what if I made the problem more difficult:
Lets say I have 10 tests
The results could be: Pass, Fail, In Progress, or Blocked
If ALL cells equal Pass, the test is marked "Pass"
If ANY cell Fails, the test is marked...