conditional formatting - like reverse lookup

lezawang

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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,012
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,559
That is really amazing. Thanks a lot for the help. I appreciate it.
 

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,090,234
Messages
5,413,226
Members
403,468
Latest member
adenard

This Week's Hot Topics

Top