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
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
Ralph | YES/NO | Number | Opened by | Description | Work notes | Active | |||
Anna | 418494 | Ralph | asdasd | TRUE | |||||
Anna | 418463 | Anna | sdas | TRUE | |||||
Albert | 418400 | Anna | das | TRUE | |||||
Rolando | 417915 | Albert | das | TRUE | |||||
Misheal | 418196 | Rolando | das | TRUE | |||||
Lope | 417293 | Misheal | sdas | TRUE | |||||
Richard | 417019 | Lope | ASDASd | TRUE | |||||
Kirubakaran | 416928 | Richard | Asd | TRUE | |||||
Jesse | 416700 | Kirubakaran | v AS | TRUE | |||||
Ariel | 418163 | Jesse | ebvge | TRUE | |||||
Ariel | 417063 | Ariel | hne | TRUE | |||||
Richard | 416870 | Ariel | thy | TRUE | |||||
Robin | 416884 | Richard | ner | TRUE | |||||
Victoria | 416877 | Robin | tw | TRUE | |||||
Gurprit | 417954 | Victoria | FC | TRUE | |||||
Omprakash | 417437 | Gurprit | eat | TRUE | |||||
Alexander | 417160 | Omprakash | BZD | TRUE | |||||
Christopher | 416974 | Alexander | FVZDSF | TRUE | |||||
Christopher | 417054 | Christopher | DVZS | TRUE | |||||
Joel | 416919 | Christopher | DFZ | TRUE | |||||
Chelsea | 418511 | Joel | STSZD | TRUE | |||||
Chelsea | 418197 | Chelsea | FVSD | TRUE | |||||
Shin | 417978 | Chelsea | VF | TRUE | |||||
Nina | |||||||||
Yasmin |