conditional formatting - like reverse lookup

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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.


nametest1test2test3averageresult
mary177996580pass
adam180466865pass
li198342452pass
sue155353742fail
jack1100865279pass
linda180584862pass
mary26710929fail
adam250666059pass
li24292245fail

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,598
Office Version
365
Platform
Windows
Simply select A2:A whatever & F2:F whatever & use
=$F2="pass"
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
That is really amazing. Thanks a lot for the help. I appreciate it.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,598
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,098,998
Messages
5,465,897
Members
406,453
Latest member
CeReaLK

This Week's Hot Topics

Top