Hi Great Master of Excel,
Id like to seek help on how i can make this possible.
I need YES or NO to appear on a Cell if the Name is found under opened by using the list on column A
I tried conditional formatting but i couldn't seem to get it. Thank you
[TABLE="width: 730"]
[TR]
[TD="align: left"]Ralph[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: left"]YES/NO[/TD]
[TD="align: left"]Number[/TD]
[TD="align: left"]Opened by[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"]Work notes[/TD]
[TD="align: left"]Active[/TD]
[/TR]
[TR]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418494[/TD]
[TD="align: left"]Ralph[/TD]
[TD] [/TD]
[TD="align: left"]asdasd[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418463[/TD]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD="align: left"]sdas[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Albert[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418400[/TD]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Rolando[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417915[/TD]
[TD="align: left"]Albert[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Misheal[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418196[/TD]
[TD="align: left"]Rolando[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Lope[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417293[/TD]
[TD="align: left"]Misheal[/TD]
[TD] [/TD]
[TD="align: left"]sdas[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417019[/TD]
[TD="align: left"]Lope[/TD]
[TD] [/TD]
[TD="align: left"]ASDASd [/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Kirubakaran[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416928[/TD]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD="align: left"]Asd[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Jesse[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416700[/TD]
[TD="align: left"]Kirubakaran[/TD]
[TD] [/TD]
[TD="align: left"]v AS[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418163[/TD]
[TD="align: left"]Jesse[/TD]
[TD] [/TD]
[TD="align: left"]ebvge[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417063[/TD]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD="align: left"]hne[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416870[/TD]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD="align: left"]thy[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Robin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416884[/TD]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD="align: left"]ner[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Victoria[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416877[/TD]
[TD="align: left"]Robin[/TD]
[TD] [/TD]
[TD="align: left"]tw[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Gurprit[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417954[/TD]
[TD="align: left"]Victoria[/TD]
[TD] [/TD]
[TD="align: left"]FC[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Omprakash[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417437[/TD]
[TD="align: left"]Gurprit[/TD]
[TD] [/TD]
[TD="align: left"]eat[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Alexander[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417160[/TD]
[TD="align: left"]Omprakash[/TD]
[TD] [/TD]
[TD="align: left"]BZD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416974[/TD]
[TD="align: left"]Alexander[/TD]
[TD] [/TD]
[TD="align: left"]FVZDSF[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417054[/TD]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD="align: left"]DVZS[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Joel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416919[/TD]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD="align: left"]DFZ[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418511[/TD]
[TD="align: left"]Joel[/TD]
[TD] [/TD]
[TD="align: left"]STSZD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418197[/TD]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD="align: left"]FVSD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Shin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417978[/TD]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD="align: left"]VF[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Nina[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Yasmin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[/TABLE]
Id like to seek help on how i can make this possible.
I need YES or NO to appear on a Cell if the Name is found under opened by using the list on column A
I tried conditional formatting but i couldn't seem to get it. Thank you
[TABLE="width: 730"]
[TR]
[TD="align: left"]Ralph[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: left"]YES/NO[/TD]
[TD="align: left"]Number[/TD]
[TD="align: left"]Opened by[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"]Work notes[/TD]
[TD="align: left"]Active[/TD]
[/TR]
[TR]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418494[/TD]
[TD="align: left"]Ralph[/TD]
[TD] [/TD]
[TD="align: left"]asdasd[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418463[/TD]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD="align: left"]sdas[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Albert[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418400[/TD]
[TD="align: left"]Anna[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Rolando[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417915[/TD]
[TD="align: left"]Albert[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Misheal[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418196[/TD]
[TD="align: left"]Rolando[/TD]
[TD] [/TD]
[TD="align: left"]das[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Lope[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417293[/TD]
[TD="align: left"]Misheal[/TD]
[TD] [/TD]
[TD="align: left"]sdas[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417019[/TD]
[TD="align: left"]Lope[/TD]
[TD] [/TD]
[TD="align: left"]ASDASd [/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Kirubakaran[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416928[/TD]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD="align: left"]Asd[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Jesse[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416700[/TD]
[TD="align: left"]Kirubakaran[/TD]
[TD] [/TD]
[TD="align: left"]v AS[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418163[/TD]
[TD="align: left"]Jesse[/TD]
[TD] [/TD]
[TD="align: left"]ebvge[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417063[/TD]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD="align: left"]hne[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416870[/TD]
[TD="align: left"]Ariel[/TD]
[TD] [/TD]
[TD="align: left"]thy[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Robin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416884[/TD]
[TD="align: left"]Richard[/TD]
[TD] [/TD]
[TD="align: left"]ner[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Victoria[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416877[/TD]
[TD="align: left"]Robin[/TD]
[TD] [/TD]
[TD="align: left"]tw[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Gurprit[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417954[/TD]
[TD="align: left"]Victoria[/TD]
[TD] [/TD]
[TD="align: left"]FC[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Omprakash[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417437[/TD]
[TD="align: left"]Gurprit[/TD]
[TD] [/TD]
[TD="align: left"]eat[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Alexander[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417160[/TD]
[TD="align: left"]Omprakash[/TD]
[TD] [/TD]
[TD="align: left"]BZD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416974[/TD]
[TD="align: left"]Alexander[/TD]
[TD] [/TD]
[TD="align: left"]FVZDSF[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417054[/TD]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD="align: left"]DVZS[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Joel[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]416919[/TD]
[TD="align: left"]Christopher[/TD]
[TD] [/TD]
[TD="align: left"]DFZ[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418511[/TD]
[TD="align: left"]Joel[/TD]
[TD] [/TD]
[TD="align: left"]STSZD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]418197[/TD]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD="align: left"]FVSD[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Shin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]417978[/TD]
[TD="align: left"]Chelsea[/TD]
[TD] [/TD]
[TD="align: left"]VF[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: left"]Nina[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Yasmin[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[/TABLE]