lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to highlight "pass" in result column to different color but not only pass but student name that correspond to that pass
For example, cell F2 = pass should be highlighted to different color and also Mary1 as well (like reverse lookup)
I can use conditional formatting to highlight pass to different color but was not able to combine the name as well. Is that possible? Thank you very much.
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
I want to highlight "pass" in result column to different color but not only pass but student name that correspond to that pass
For example, cell F2 = pass should be highlighted to different color and also Mary1 as well (like reverse lookup)
I can use conditional formatting to highlight pass to different color but was not able to combine the name as well. Is that possible? Thank you very much.
name | test1 | test2 | test3 | average | result |
mary1 | 77 | 99 | 65 | 80 | pass |
adam1 | 80 | 46 | 68 | 65 | pass |
li1 | 98 | 34 | 24 | 52 | pass |
sue1 | 55 | 35 | 37 | 42 | fail |
jack1 | 100 | 86 | 52 | 79 | pass |
linda1 | 80 | 58 | 48 | 62 | pass |
mary2 | 67 | 10 | 9 | 29 | fail |
adam2 | 50 | 66 | 60 | 59 | pass |
li2 | 42 | 92 | 2 | 45 | fail |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>