Find entries in a sheet available or not

[AFZAL SOHAIL]

Dear Team,
I need your help, I have an excel file I need a formula to find out the entries in col-C is available in Col-G or not, if available then highlights this row also
I attached the file:
Thanks a lot.

SR.NO.	Name	Position	Joining Date	Sr.No.​	Name​	Designation​
1​	Hafiz Hussain Ahmad​	Network Technician​	08-01-24​	1​	Zulfiqar Ali​	Associate Network Technician​
2​	Hafiz M Babar Ishaq​	Supervisor - Deployment​	29-02-24​	2​	muhammad Arif Anjum​	Associate Network Technician​
3​	Basit Aziz Ullah​	Executive - Deployment​	29-01-24​	3​	Muhammad Ilyas​	Associate Network Technician​
4​	Muhammad Suleman​	Supervisor - Deployment​	13-02-24​	4​	RAI M Zergham KHAN​	Associate Network Technician​
5​	Hamid Maqbool​	Sr. Network Technician​	23-04-19​	5​	Muhammad Tariq Hanif​	Associate Network Technician​
6​	Syed Ali Raza​	Supervisior - QA​	20-02-24​	6​	Abdul Hannan Ali​	Associate Network Technician​
7​	Mehmood Ali Khalid​	Supervisor - Field Operations​	01-02-24​	7​	Muhammad Daud Malik​	Associate Network Technician​
8​	Wali Ur Rehman​	Network Technician​	21-05-15​	8​	Ali Sanwal​	Associate Network Technician​
9​	Shahid Nazir​	Rigger​	01-01-16​	9​	Syed Asad Ali​	Associate Network Technician​
10​	Muhammad Haseeb Javed​	Supervisor - Deployment​	01-02-24​	10​	Talha Naveed​	Associate Network Technician​
11​	Muhammad Hamza Javed​	Team Lead - Deployment​	29-01-24​	11​	Arslan Ahmad​	Associate Network Technician​
12​	Abdullah Raza​	Technical Support Associate​	07-12-22​	12​	Muhammad Husnain​	Associate Network Technician​
13​	Muhammad Kamran​	Sr. Network Technician​	01-02-24​	13​	Muhammad Asim​	Driver​
14​	Aon Muhammad​	Splicer​	03-02-17​	14​	Muhammad Shafiq​	Driver​
15​	Azhar Ali​	Supervisor - Field Operations​	01-02-24​	15​	Imran Ahmed​	Driver​
16​	Umair Chaudhry​	Splicer​	01-02-24​	16​	Muhammad Amin shahid​	Driver​
17​	Adnan Majeed​	Technical Associate​	03-02-17​	17​	Nasir Arfat​	Driver​
18​	Muhammad Ibrahim​	Driver​	03-02-17​	18​	Hafiz Muhammad Imtiaz​	Driver​
19​	Muhammad Riaz​	Technical Assistant​	21-03-17​	19​	Ali Raza​	Driver​
20​	Muhammad Asim​	Driver​	18-03-20​	20​	Imran Karamat​	Driver​
21​	Muhammad Shafiq​	Driver​	21-03-17​	21​	Rana Muhammad Mubeen Ud Din​	Driver​
22​	Zulfiqar Ali​	Associate Network Technician​	21-03-17​	22​	Muhammad Adnan​	Driver​
23​	Haris Lateef​	Sr. Technical Support Representative​	03-11-23​	23​	Muhammad Kashif​	Manager - Fiber Operations​
24​	Haris Naveed​	Network Technician​	08-06-17​	24​	Hassan Ali​	Network Technician​
25​	Imran Ahmed​	Driver​	17-07-17​	25​	Aon Muhammad​	Splicer​
26​	Muhammad Amin shahid​	Driver​	18-07-17​	26​	Muhammad Irfan​	Splicer​
27​	Vikram Javed​	Sr. Rigger​	24-05-22​	27​	Yasir Ali​	Splicer​
28​	Muhammad Usama Habib​	Team Lead - Deployment​	02-02-24​	28​	Muhammad Sajjad​	Splicer​
29​	Sajjad Ali​	Associate Network Technician​	18-08-17​	29​	Muhmmad Faizan​	Splicer​
30​	Hafiz Atif​	Supervisior - QA​	21-02-24​	30​	Muhammad Asim Shahzad​	Splicer​
31​	Hafiz Waseem Iqbal​	Sr. Splicer​	04-05-18​	31​	Muhammad Ahsan​	Splicer​
32​	Faisal Maqsood​	Technical Assistant​	19-07-17​	32​	Muhammad Imran​	Splicer​
33​	muhammad Arif Anjum​	Associate Network Technician​	19-07-17​	33​	Hafiz Habib Ullah​	Splicer​
34​	Muhammad Asim​	Technical Associate​	03-10-17​	34​	Shabir Hussain​	Splicer​
35​	Muhammad Adil Jahangir​	Technical Associate​	03-10-17​	35​	Khalid Ali​	Sr. Splicer​
36​	Ramis James​	Sr. Rigger​	09-05-18​	36​	Mehmood Ali Khalid​	Supervisor - Field Operations​
37​	Farhan Khursheed​	Sr. Rigger​	09-05-18​	37​	Ikram Hussain​	Supervisor - Field Operations​
38​	Muhammad Anwar Ishaq​	Sr. Rigger​	10-09-18​	38​	Faisal Maqsood​	Technical Assistant​
39​	Salman Shahzad​	Supervisior - QA​	20-02-24​	39​	Muhammad Arslan​	Technical Assistant​
40​	Salman Mukhtar​	Technical Assistant​	12-01-19​	40​	Muhammad Nadeem​	Technical Assistant​
41​	Muhammad Arslan​	Technical Assistant​	12-01-19​	41​	Muhammad Akmal​	Technical Assistant​
42​	Muhammad Nadeem​	Technical Assistant​	12-01-19​	42​	Muhammad Babar​	Technical Assistant​
43​	Hassan Ali​	Network Technician​	18-04-19​	43​	Abhishik Danish​	Technical Assistant​
44​	Muhammad Gulfam Tariq​	Supervisior - QA​	13-02-24​	44​	Muhammad Asim​	Technical Associate​
45​	Muhammad Kashif​	Supervisor - Field Operations​	01-02-24​	45​	Muhammad Adil Jahangir​	Technical Associate​
46​	Muhammad Aftab Hanif​	Network Technician​	25-04-19​	46​	Sami Ullah​	Technical Associate​
47​	Mirza Safwan Baig​	Sr. Network Technician​	18-04-19​	47​	Hasnain Ghani​	Technical Associate​
48​	Nasir Arfat​	Driver​	29-05-19​	48​	Waheed Mahmood​	Technical Associate​
49​	Muhammad Usman Mahmood​	Sr. Network Technician​	10-06-19​	49​	Ali Hira​	Technical Associate​
50​	Ibtasam Afzal​	Splicer​	11-05-23​	50​	Syed Ali Murtaza​	Technical Associate​
51​	Suleman Khalil​	Rigger​	26-07-19​	51​	Muhammad Azhar Saroosh Naqeeb​	Technical Associate​
52​	Muhammad Akmal​	Technical Assistant​	04-09-19​	52​	Muhammad Umar​	Technical Associate​
53​	Muhammad Irfan​	Splicer​	04-09-19​	53​	Muhammad Arslan​	Technical Associate​
54​	Danish Masih​	Technical Associate​	04-09-19​	54​	Muhammad Noman​	Technical Associate​
55​	Muhammad Ilyas​	Associate Network Technician​	16-09-19​	55​	Uzair Qasim​	Technical Associate​
56​	Yasir Ali​	Splicer​	19-09-19​	56​	Inam Ul Mustafa​	Technical Associate​
57​	Muhammad Hamza​	Team Lead- Deployment​	01-02-24​	57​	Muhammad Adeel​	Technical Associate​
58​	Muhammad Ans Irfan​	Manager - Deployment​	21-08-23​	58​	Hassan Maqsood​	Technical Associate​
59​	Sami Ullah​	Technical Associate​	13-03-20​	59​	Dawood Ali​	Technical Associate​
60​	Adeel Nazeer​	Technical Associate​	01-01-20​	60​	Aneeq Ahmad​	Technical Associate​
61​	Muhammad Hasnain​	Associate Network Technician​	09-10-23​	61​	Farrukh Ehsan Baig​	Driver​
62​	Zeeshan Ahmad​	Technical Associate​	01-01-20​	62​	Muhammad Hussain Hani​	Power Technician​
63​	Waqas Ilyas​	Driver​	01-01-20​	63​	Irtiza Ali​	Rigger​
64​	Haider Ali​	Driver​	01-01-20​	64​	Farhan Bashir​	Manager - Fiber Operations​
65​	Mohsin Mujtaba​	Driver​	21-01-20​
66​	Daud​	Splicer​	30-01-24​
67​	Arbab Ahmad​	Associate Network Technician​	08-12-23​
68​	Muhammad Sajjad​	Splicer​	17-02-20​
69​	Hasnain Ghani​	Technical Associate​	21-02-20​
70​	RAI M Zergham KHAN​	Associate Network Technician​	20-05-20​
71​	Ghulam Abbas​	Associate Network Technician​	09-06-20​
72​	Muhammad Muzaib Manzoor​	Associate Network Technician​	09-06-20​
73​	Mujahid Ali​	Associate Network Technician​	09-06-20​
74​	Muhammad Bilal​	Associate Network Technician​	09-06-20​
75​	Muhammad Hussain Hani​	Power Technician​	08-06-20​
76​	Raza Haider​	Associate Power Technician​	08-06-20​
77​	Noor Ahmad​	Network Technician​	08-06-20​
78​	Ijaz Ahmad​	Network Technician​	08-06-20​
79​	Shahzad Shafique​	Driver​	24-08-20​
80​	Hassan Maqsood​	Technical Associate​	08-10-20​
81​	Muhammad Waqas​	Technical Associate​	08-10-20​
82​	Muhammad Naeem​	Technical Associate​	20-10-20​
83​	Muhammad Usman​	Technical Associate​	11-11-20​
84​	Muhammad Muneeb Ur Rehman​	Network Technician​	01-02-24​
85​	Ramzan Shah​	Technical Associate​	21-06-21​
86​	Rashid Arshad Ali​	Splicer​	07-06-21​
87​	Muhammad Saeed Khan​	Driver​	18-05-21​
88​	Waheed Mahmood​	Technical Associate​	23-07-21​
89​	Hafiz Muhammad Imtiaz​	Driver​	29-07-21​
90​	Abdullah Khalil​	Executive - Deployment​	21-02-24​
91​	Muhammad Tariq Hanif​	Associate Network Technician​	13-09-21​
92​	Muhammad Naeem Ansari​	Supervisor - Deployment​	13-02-24​
93​	Abdul Hannan Ali​	Associate Network Technician​	28-09-21​
94​	Adeel Abbas​	Supervisior - QA​	21-02-24​
95​	Malik Arham Jaa​	Supervisior - QA​	20-02-24​
96​	Faiz ur Rehman​	Supervisior - QA​	21-02-24​
97​	Muhammad Tayyab​	Supervisor - Deployment​	29-01-24​
98​	Syed Muhammad Mehdi​	Technical Associate​	08-12-21​
99​	Muhammad Hussnain​	Associate Network Technician​	08-12-21​
100​	Rehan Ali​	Technical Support Associate​	15-02-22​
101​	Muhammad Bilal Ahmad​	Network Technician​	07-02-22​
102​	Muhmmad Faizan​	Splicer​	07-03-22​
103​	Saghir Ahmed Bhatti​	Technical Associate​	23-02-22​
104​	Shahid Shoaib​	Technical Associate​	23-02-22​
105​	Amir Munir​	Splicer​	23-02-22​
106​	Muhammad Daud Malik​	Associate Network Technician​	25-03-22​
107​	Muhammad Nasir​	Executive - Deployment​	29-01-24​
108​	Ali Hira​	Technical Associate​	21-04-22​
109​	Muhammad Asim Shahzad​	Splicer​	01-03-24​
110​	Syed Ali Murtaza​	Technical Associate​	21-04-22​
111​	Muhammad Zia Ullah​	Executive - Fiber Operations​	03-04-24​
112​	Umair Nawaz​	Team Lead - Deployment​	29-01-24​
113​	Muhammad John Raza​	Supervisior - QA​	06-05-22​
114​	M Ahsan Ahmed Siddiqui​	Technician - Deployment​	29-04-22​
115​	Muhammad Shoaib​	Manager - Deployment​	01-04-24​
116​	Muhammad Hamza Shahid​	Supervisior - QA​	06-02-24​
117​	Ahsan Jamil​	Team Lead - Deployment​	29-01-24​
118​	Maqsood Shahzad​	Supervisior - QA​	06-05-22​
119​	Usama Abid​	Supervisior - QA​	10-05-22​
120​	Muhammad Shahzaib​	Technical Associate​	16-04-22​
121​	Dawood Ali​	Technical Associate​	20-04-22​
122​	Aneeq Ahmad​	Technical Associate​	20-04-22​
123​	Asif Ali​	Supervisior - QA​	10-05-22​
124​	Zeeshan​	Supervisior - QA​	10-05-22​
125​	Muhammad Husnain Butt​	Supervisior - QA​	21-02-24​
126​	Muhammad Azhar Saroosh Naqeeb​	Technical Associate​	27-06-22​
127​	Muhammad Umar​	Technical Associate​	27-06-22​
128​	Muhammad Farooq Yasin​	Executive- QA​	23-11-23​
129​	Muhammad Talha Shehroz​	Supervisor - Deployment​	15-02-24​
130​	Hamza Zulfiqar​	Executive - Deployment​	29-01-24​
131​	Muhammad Ahsan​	Splicer​	18-08-22​
132​	Muhammad Qasim​	Supervisior - QA​	03-02-24​
133​	Hammad Ahmad​	Technical Associate​	05-09-22​
134​	Abdul Rehman​	Technical Associate​	08-09-22​
135​	Muhammad Usman Hader​	Associate Network Technician​	13-09-22​
136​	Fakhara Chaudhary​	Technical Support Associate​	15-09-22​
137​	Ali Sanwal​	Associate Network Technician​	08-09-22​
138​	Ali Raza​	Driver​	29-09-22​
139​	Imran Karamat​	Driver​	29-09-22​
140​	Muhammad Babar​	Technical Assistant​	30-09-22​
141​	Bilal Butt​	Driver​	07-10-22​
142​	Farrukh Ehsan Baig​	Driver​	12-10-22​
143​	Shaharyar Zulfiqar Ali​	Network Technician​	25-10-22​
144​	Adal Waqar​	Technical Associate​	07-11-22​
145​	Muhammad Ibrar​	Technical Associate​	07-11-22​
146​	Sikandar Abbas​	Network Technician​	15-11-22​
147​	Muhammad Usama Tanvir​	Technical Support Associate​	25-11-22​
148​	Muhammad Hassan​	Splicer​	08-12-22​
149​	Hamza Naveed​	Associate Network Technician​	09-12-22​
150​	Adil Tabassum​	Driver​	08-12-22​
151​	Hafiz Muhammad Muneeb Ahmad​	Team Lead - Deployment​	29-01-24​
152​	Areeb Ahmad​	Technical Support Associate​	13-01-23​
153​	Muhammad Ahmad Arshad​	Network Technician​	01-02-24​
154​	Syed Faizan Ali​	Technical Associate​	06-02-23​
155​	Abu Bakar Siddique​	Supervisor - Deployment​	29-01-24​
156​	Muhammad Arslan​	Technical Associate​	20-02-23​
157​	Muhammad Imran​	Splicer​	02-03-23​
158​	Muhammad Usman​	Supervisor - Deployment​	01-02-24​
159​	Fasih Ur Rehman​	Executive- QA​	14-11-23​
160​	Ghulam Murtaza​	Supervisior - QA​	24-03-23​
161​	Kashif Iqbal​	GIS Surveyor​	27-03-23​
162​	Hamza Jamal Pasha​	Associate Network Technician​	30-03-23​
163​	Aftab Ahmad​	Executive - Deployment​	16-01-24​
164​	Muhammad Zeeshan Iqbal​	Supervisor - Deployment​	05-03-24​
165​	Asad Ali​	Supervisior - QA​	16-01-24​
166​	Hussam Ahmad​	Executive - Deployment​	16-01-24​
167​	Usman Ahmad​	Supervisor - Deployment​	01-02-24​
168​	Uzair Qasim​	Technical Associate​	23-06-23​
169​	Nadeem Ahmad​	Supervisor - Deployment​	29-01-24​
170​	Nadeem Ijaz​	Supervisior - QA​	21-08-23​
171​	Muhammad Shafiq​	Technician - Deployment​	25-07-23​
172​	Inam Ul Mustafa​	Technical Associate​	01-08-22​
173​	Muhammad Kashif​	Manager - Fiber Operations​	21-08-23​
174​	Rana Muhammad Mubeen Ud Din​	Driver​	30-08-23​
175​	Muhammad Bilal Fareed​	Driver​	30-08-23​
176​	Sheikh Muhammad Hamza​	Driver​	31-08-23​
177​	Syed Asad Ali​	Associate Network Technician​	05-08-23​
178​	Muhammad Ali Raza​	Executive- QA​	01-02-24​
179​	Haris Usman​	Supervisior - QA​	11-09-23​
180​	Abhishik Danish​	Technical Assistant​	18-09-23​
181​	Abdul Qadeer​	Supervisor - Deployment​	06-02-24​
182​	Muhammad Ashar Anjum​	Supervisior - QA​	20-02-24​
183​	Talha Naveed​	Associate Network Technician​	20-09-23​
184​	Fasir Nazir​	Associate Network Technician​	02-10-23​
185​	Aqeel Ahmed​	Splicer​	06-10-23​
186​	Muhammad Yasir​	Technician - Deployment​	06-12-23​
187​	Shehroz Yameen​	Splicer​	06-10-23​
188​	Muhammad Abbas​	Supervisor- Deployment​	15-02-24​
189​	Khawaja Shaheryar Ahmad​	Supervisior - QA​	01-02-24​
190​	Muhammad Ahmad Majid​	Executive- QA​	31-10-23​
191​	Faraz Bajwa​	Supervisior - QA​	20-02-24​
192​	Arslan Ahmad​	Associate Network Technician​	10-10-23​
193​	Muhammad Adnan​	Driver​	23-10-23​
194​	Raheel Ahmad​	AC Technician​	03-11-23​
195​	Muhammad Faizan​	Technician - Deployment​	23-11-23​
196​	Subhan Ali​	Technician - Deployment​	23-11-23​
197​	Abdullah Pervaiz​	Technician - Deployment​	29-11-23​
198​	Muhammad Ahmad Hassan Bhatti​	Sr. Network Technician​	30-11-23​
199​	Usama Iqbal​	Technical Support Associate​	30-11-23​
200​	Irtiza Ali​	Rigger​	30-11-23​
201​	Amir Shahzad​	Technical Support Associate​	30-11-23​
202​	Hafiz Habib Ullah​	Splicer​	05-12-23​
203​	Adeel Ahmad Khan​	Executive - Planning​	23-11-23​
204​	Abdul Qayyum​	Manager - QA​	23-11-23​
205​	Shraf Riaz​	Supervisior - QA​	08-12-23​
206​	Muhammad Usama Mubarak​	Supervisior - QA​	12-12-23​
207​	Fahad Arshad​	Technical Support Representative​	18-12-23​
208​	Hasnain Ali Shah​	Technical Associate​	18-12-23​
209​	Muhammad Husnain​	Associate Network Technician​	03-01-24​
210​	Syed Hassan Raza​	Technician - Deployment​	08-01-24​
211​	Abdullah Ahmad​	Technician - Deployment​	12-01-24​
212​	Abdul Wasiq​	Supervisior - QA​	17-01-24​
213​	Shabir Hussain​	Splicer​	18-01-24​
214​	Shoukat Ali​	Rigger​	18-01-24​
215​	Ziam Ahmad​	Supervisior - QA​	18-01-24​
216​	Shahzaib Ali​	Supervisior - QA​	22-01-24​
217​	Nauman Abid Chaudhary​	Executive- QA​	16-01-24​
218​	Muhammad Daniyal Badar​	Executive- QA​	17-01-24​
219​	Rana Ali Hamza​	Executive- QA​	17-01-24​
220​	Muhammad Fazeel​	Supervisior - QA​	25-01-24​
221​	Kashif Khan​	Technician - Deployment​	30-01-24​
222​	Muhammad Moazam Sardar​	Technician - Deployment​	30-01-24​
223​	Hamza Ali​	Technician - Deployment​	30-01-24​
224​	Sohaim Saleem​	Technician - Deployment​	30-01-24​
225​	Abdur Rehman​	Technical Support Associate​	29-01-24​
226​	Jahanzaib​	Supervisor - Deployment​	29-01-24​
227​	Muhammad Usman​	Supervisor - Deployment​	29-01-24​
228​	Ali Imran​	Supervisor - Deployment​	15-02-24​
229​	Muhammad Awais Ali​	Technician - Deployment​	29-01-24​
230​	Furqan Hameed​	Supervisor - Deployment​	29-01-24​
231​	Adnan Saeed​	Manager - Deployment​	29-01-24​
232​	Adnan Ali​	Team Lead - Deployment​	29-01-24​
233​	Muhammad Saifullah Khalid​	Technician - Deployment​	29-01-24​
234​	Umair Farooq​	Executive - Deployment​	29-01-24​
235​	Mudasir Iqbal​	Team Lead - Deployment​	01-02-24​
236​	Abdul Aleem​	Supervisor - Deployment​	01-02-24​
237​	Zimad Nazir​	Supervisor - Deployment​	30-01-24​
238​	Muhammad Tayyab​	Executive - Deployment​	30-01-24​
239​	Syed Farhan Hassan Bukhari​	Technician - Deployment​	01-02-24​
240​	Muhammad Ali​	Team Lead - Deployment​	01-02-24​
241​	Imran Malik​	Team Lead - Deployment​	31-01-24​
242​	Muhammad Atif Ur Rehman​	Supervisor - Deployment​	01-02-24​
243​	Shahab Khan​	Supervisor - Deployment​	05-02-24​
244​	Roshnan Ali​	Supervisor - Deployment​	02-02-24​
245​	Mateen Ahmad​	Supervisor - Deployment​	01-02-24​
246​	Mehran Shahid​	Team Lead - Deployment​	31-01-24​
247​	Wajeeh Ul Hassan​	Technician - Deployment​	31-01-24​
248​	Bilal Zagham​	Supervisor - Deployment​	31-01-24​
249​	Ali Raza Ifthikhar​	Technician - Deployment​	31-01-24​
250​	Hamza Malik​	Technician - Deployment​	31-01-24​
251​	Muhammad Farhan Shehzad​	Technician - Deployment​	06-02-24​
252​	Muhammad Zohaib​	Technician - Deployment​	07-02-24​
253​	Muhammad Danyal​	Technician - Deployment​	07-02-24​
254​	Mansoor Ahmed Khan​	Executive- QA​	12-02-24​
255​	Hafiz Usman Farrukh​	Supervisior - QA​	19-02-24​
256​	Zeeshan Ul Haque​	Manager - Deployment​	01-03-24​
257​	Ali Haider​	Supervisior - QA​	14-02-24​
258​	Sarfraz Ahmad​	Supervisior - QA​	26-02-24​
259​	Faisal Ashraf​	Technician - Deployment​	14-02-24​
260​	Muhammad Asad Ehsan​	Supervisior - QA​	14-02-24​
261​	Muhammad Mehdi​	Supervisior - QA​	14-02-24​
262​	Muhammad Mudassar Akram​	Executive- QA​	13-02-24​
263​	Muhammad Bilal Asghar​	Supervisior - QA​	14-02-24​
264​	Nouman Bashir​	Supervisor - Deployment​	04-03-24​
265​	Jawad Hassan​	Executive- QA​	01-03-24​
266​	Muhammad Zeeshan​	Team Lead - Deployment​	19-02-24​
267​	Muhammad Abrar​	Team Lead - Deployment​	19-02-24​
268​	Abdullah Sajid​	Executive - Deployment​	14-02-24​
269​	Muhammad Shazil Asif Attari​	Supervisior - QA​	14-02-24​
270​	Ikram Hussain​	Supervisor - Field Operations​	01-03-24​
271​	Sanif Ur Rehman​	Supervisior - QA​	13-02-24​
272​	Haris Nazir​	Supervisior - QA​	13-02-24​
273​	Ghazanfar Gulzar​	Supervisor - Deployment​	21-02-24​
274​	Hafiz Amaz Ali​	Technician - Deployment​	21-02-24​
275​	Ahmar Ahtisham​	Technician - Deployment​	21-02-24​
276​	Mahad Ali Khan​	Executive - Deployment​	21-02-24​
277​	Junaid Ahmed​	Manager - Deployment​	21-02-24​
278​	Farhan Bashir​	Manager - Fiber Operations​	26-03-24​
279​	Nadeem Abbas​	Technician - Deployment​	23-02-24​
280​	Haseeb Ashfaq Khan​	Technician - Deployment​	29-02-24​
281​	Muhammad Adeel​	Technical Associate​	29-02-24​
282​	Muhammad Zeeshan Ali​	Executive - Deployment​	04-03-24​
283​	Muhammad Fahad Malik​	Network Technician​	01-02-24​
284​	Muhammad Athar Rana​	Executive - Deployment​	12-03-24​
285​	Wasim Akram​	Technician - Deployment​	08-04-24​
286​	Muhammad Azeem​	Associate Network Technician​	19-04-24​
287​	Muhammad Zeeshan​	Technical Associate​	23-04-24​

 

[awoohaw]

Are you just looking for any appearance of the value? Or are you trying to only highlight rows as they are "checked" off the list?

try this:

Book1
	A	B	C	D	E	F	G
1	SR.NO.	Name	Position	Joining Date	Sr.No.	Name	Designation
2	1	Hafiz Hussain Ahmad	Network Technician	2024-01-08	1	Zulfiqar Ali	Associate Network Technician
3	2	Hafiz M Babar Ishaq	Supervisor - Deployment	2024-02-29	2	muhammad Arif Anjum	Associate Network Technician
4	3	Basit Aziz Ullah	Executive - Deployment	2024-01-29	3	Muhammad Ilyas	Associate Network Technician
5	4	Muhammad Suleman	Supervisor - Deployment	2024-02-13	4	RAI M Zergham KHAN	Associate Network Technician
6	5	Hamid Maqbool	Sr. Network Technician	2019-04-23	5	Muhammad Tariq Hanif	Associate Network Technician
7	6	Syed Ali Raza	Supervisior - QA	2024-02-20	6	Abdul Hannan Ali	Associate Network Technician
8	7	Mehmood Ali Khalid	Supervisor - Field Operations	2024-02-01	7	Muhammad Daud Malik	Associate Network Technician
9	8	Wali Ur Rehman	Network Technician	2015-05-21	8	Ali Sanwal	Associate Network Technician
10	9	Shahid Nazir	Rigger	2016-01-01	9	Syed Asad Ali	Associate Network Technician
11	10	Muhammad Haseeb Javed	Supervisor - Deployment	2024-02-01	10	Talha Naveed	Associate Network Technician
12	11	Muhammad Hamza Javed	Team Lead - Deployment	2024-01-29	11	Arslan Ahmad	Associate Network Technician
13	12	Abdullah Raza	Technical Support Associate	2022-12-07	12	Muhammad Husnain	Associate Network Technician
14	13	Muhammad Kamran	Sr. Network Technician	2024-02-01	13	Muhammad Asim	Driver
15	14	Aon Muhammad	Splicer	2017-02-03	14	Muhammad Shafiq	Driver
16	15	Azhar Ali	Supervisor - Field Operations	2024-02-01	15	Imran Ahmed	Driver
17	16	Umair Chaudhry	Splicer	2024-02-01	16	Muhammad Amin shahid	Driver
18	17	Adnan Majeed	Technical Associate	2017-02-03	17	Nasir Arfat	Driver
19	18	Muhammad Ibrahim	Driver	2017-02-03	18	Hafiz Muhammad Imtiaz	Driver
20	19	Muhammad Riaz	Technical Assistant	2017-03-21	19	Ali Raza	Driver
21	20	Muhammad Asim	Driver	2020-03-18	20	Imran Karamat	Driver
22	21	Muhammad Shafiq	Driver	2017-03-21	21	Rana Muhammad Mubeen Ud Din	Driver
23	22	Zulfiqar Ali	Associate Network Technician	2017-03-21	22	Muhammad Adnan	Driver
24	23	Haris Lateef	Sr. Technical Support Representative	2023-11-03	23	Muhammad Kashif	Manager - Fiber Operations
25	24	Haris Naveed	Network Technician	2017-06-08	24	Hassan Ali	Network Technician
26	25	Imran Ahmed	Driver	2017-07-17	25	Aon Muhammad	Splicer
27	26	Muhammad Amin shahid	Driver	2017-07-18	26	Muhammad Irfan	Splicer
28	27	Vikram Javed	Sr. Rigger	2022-05-24	27	Yasir Ali	Splicer
29	28	Muhammad Usama Habib	Team Lead - Deployment	2024-02-02	28	Muhammad Sajjad	Splicer
30	29	Sajjad Ali	Associate Network Technician	2017-08-18	29	Muhmmad Faizan	Splicer
31	30	Hafiz Atif	Supervisior - QA	2024-02-21	30	Muhammad Asim Shahzad	Splicer
32	31	Hafiz Waseem Iqbal	Sr. Splicer	2018-05-04	31	Muhammad Ahsan	Splicer
33	32	Faisal Maqsood	Technical Assistant	2017-07-19	32	Muhammad Imran	Splicer
34	33	muhammad Arif Anjum	Associate Network Technician	2017-07-19	33	Hafiz Habib Ullah	Splicer
35	34	Muhammad Asim	Technical Associate	2017-10-03	34	Shabir Hussain	Splicer
36	35	Muhammad Adil Jahangir	Technical Associate	2017-10-03	35	Khalid Ali	Sr. Splicer
37	36	Ramis James	Sr. Rigger	2018-05-09	36	Mehmood Ali Khalid	Supervisor - Field Operations
38	37	Farhan Khursheed	Sr. Rigger	2018-05-09	37	Ikram Hussain	Supervisor - Field Operations
39	38	Muhammad Anwar Ishaq	Sr. Rigger	2018-09-10	38	Faisal Maqsood	Technical Assistant
40	39	Salman Shahzad	Supervisior - QA	2024-02-20	39	Muhammad Arslan	Technical Assistant
41	40	Salman Mukhtar	Technical Assistant	2019-01-12	40	Muhammad Nadeem	Technical Assistant
42	41	Muhammad Arslan	Technical Assistant	2019-01-12	41	Muhammad Akmal	Technical Assistant
43	42	Muhammad Nadeem	Technical Assistant	2019-01-12	42	Muhammad Babar	Technical Assistant
44	43	Hassan Ali	Network Technician	2019-04-18	43	Abhishik Danish	Technical Assistant
45	44	Muhammad Gulfam Tariq	Supervisior - QA	2024-02-13	44	Muhammad Asim	Technical Associate
46	45	Muhammad Kashif	Supervisor - Field Operations	2024-02-01	45	Muhammad Adil Jahangir	Technical Associate
47	46	Muhammad Aftab Hanif	Network Technician	2019-04-25	46	Sami Ullah	Technical Associate
48	47	Mirza Safwan Baig	Sr. Network Technician	2019-04-18	47	Hasnain Ghani	Technical Associate
49	48	Nasir Arfat	Driver	2019-05-29	48	Waheed Mahmood	Technical Associate
50	49	Muhammad Usman Mahmood	Sr. Network Technician	2019-06-10	49	Ali Hira	Technical Associate
51	50	Ibtasam Afzal	Splicer	2023-05-11	50	Syed Ali Murtaza	Technical Associate
52	51	Suleman Khalil	Rigger	2019-07-26	51	Muhammad Azhar Saroosh Naqeeb	Technical Associate
53	52	Muhammad Akmal	Technical Assistant	2019-09-04	52	Muhammad Umar	Technical Associate
54	53	Muhammad Irfan	Splicer	2019-09-04	53	Muhammad Arslan	Technical Associate
55	54	Danish Masih	Technical Associate	2019-09-04	54	Muhammad Noman	Technical Associate
56	55	Muhammad Ilyas	Associate Network Technician	2019-09-16	55	Uzair Qasim	Technical Associate
57	56	Yasir Ali	Splicer	2019-09-19	56	Inam Ul Mustafa	Technical Associate
58	57	Muhammad Hamza	Team Lead- Deployment	2024-02-01	57	Muhammad Adeel	Technical Associate
59	58	Muhammad Ans Irfan	Manager - Deployment	2023-08-21	58	Hassan Maqsood	Technical Associate
60	59	Sami Ullah	Technical Associate	2020-03-13	59	Dawood Ali	Technical Associate
61	60	Adeel Nazeer	Technical Associate	2020-01-01	60	Aneeq Ahmad	Technical Associate
62	61	Muhammad Hasnain	Associate Network Technician	2023-10-09	61	Farrukh Ehsan Baig	Driver
63	62	Zeeshan Ahmad	Technical Associate	2020-01-01	62	Muhammad Hussain Hani	Power Technician
64	63	Waqas Ilyas	Driver	2020-01-01	63	Irtiza Ali	Rigger
65	64	Haider Ali	Driver	2020-01-01	64	Farhan Bashir	Manager - Fiber Operations
66	65	Mohsin Mujtaba	Driver	2020-01-21
67	66	Daud	Splicer	2024-01-30
68	67	Arbab Ahmad	Associate Network Technician	2023-12-08
69	68	Muhammad Sajjad	Splicer	2020-02-17
70	69	Hasnain Ghani	Technical Associate	2020-02-21
71	70	RAI M Zergham KHAN	Associate Network Technician	2020-05-20
72	71	Ghulam Abbas	Associate Network Technician	2020-06-09
73	72	Muhammad Muzaib Manzoor	Associate Network Technician	2020-06-09
74	73	Mujahid Ali	Associate Network Technician	2020-06-09
75	74	Muhammad Bilal	Associate Network Technician	2020-06-09
76	75	Muhammad Hussain Hani	Power Technician	2020-06-08
77	76	Raza Haider	Associate Power Technician	2020-06-08
78	77	Noor Ahmad	Network Technician	2020-06-08
79	78	Ijaz Ahmad	Network Technician	2020-06-08
80	79	Shahzad Shafique	Driver	2020-08-24
81	80	Hassan Maqsood	Technical Associate	2020-10-08
82	81	Muhammad Waqas	Technical Associate	2020-10-08
83	82	Muhammad Naeem	Technical Associate	2020-10-20
84	83	Muhammad Usman	Technical Associate	2020-11-11
85	84	Muhammad Muneeb Ur Rehman	Network Technician	2024-02-01
86	85	Ramzan Shah	Technical Associate	2021-06-21
87	86	Rashid Arshad Ali	Splicer	2021-06-07
88	87	Muhammad Saeed Khan	Driver	2021-05-18
89	88	Waheed Mahmood	Technical Associate	2021-07-23
90	89	Hafiz Muhammad Imtiaz	Driver	2021-07-29
91	90	Abdullah Khalil	Executive - Deployment	2024-02-21
92	91	Muhammad Tariq Hanif	Associate Network Technician	2021-09-13
93	92	Muhammad Naeem Ansari	Supervisor - Deployment	2024-02-13
94	93	Abdul Hannan Ali	Associate Network Technician	2021-09-28
95	94	Adeel Abbas	Supervisior - QA	2024-02-21
96	95	Malik Arham Jaa	Supervisior - QA	2024-02-20
97	96	Faiz ur Rehman	Supervisior - QA	2024-02-21
98	97	Muhammad Tayyab	Supervisor - Deployment	2024-01-29
99	98	Syed Muhammad Mehdi	Technical Associate	2021-12-08
100	99	Muhammad Hussnain	Associate Network Technician	2021-12-08
101	100	Rehan Ali	Technical Support Associate	2022-02-15
102	101	Muhammad Bilal Ahmad	Network Technician	2022-02-07
103	102	Muhmmad Faizan	Splicer	2022-03-07
104	103	Saghir Ahmed Bhatti	Technical Associate	2022-02-23
105	104	Shahid Shoaib	Technical Associate	2022-02-23
106	105	Amir Munir	Splicer	2022-02-23
107	106	Muhammad Daud Malik	Associate Network Technician	2022-03-25
108	107	Muhammad Nasir	Executive - Deployment	2024-01-29
109	108	Ali Hira	Technical Associate	2022-04-21
110	109	Muhammad Asim Shahzad	Splicer	2024-03-01
111	110	Syed Ali Murtaza	Technical Associate	2022-04-21
112	111	Muhammad Zia Ullah	Executive - Fiber Operations	2024-04-03
113	112	Umair Nawaz	Team Lead - Deployment	2024-01-29
114	113	Muhammad John Raza	Supervisior - QA	2022-05-06
115	114	M Ahsan Ahmed Siddiqui	Technician - Deployment	2022-04-29
116	115	Muhammad Shoaib	Manager - Deployment	2024-04-01
117	116	Muhammad Hamza Shahid	Supervisior - QA	2024-02-06
118	117	Ahsan Jamil	Team Lead - Deployment	2024-01-29
119	118	Maqsood Shahzad	Supervisior - QA	2022-05-06
120	119	Usama Abid	Supervisior - QA	2022-05-10
121	120	Muhammad Shahzaib	Technical Associate	2022-04-16
122	121	Dawood Ali	Technical Associate	2022-04-20
123	122	Aneeq Ahmad	Technical Associate	2022-04-20
124	123	Asif Ali	Supervisior - QA	2022-05-10
125	124	Zeeshan	Supervisior - QA	2022-05-10
126	125	Muhammad Husnain Butt	Supervisior - QA	2024-02-21
127	126	Muhammad Azhar Saroosh Naqeeb	Technical Associate	2022-06-27
128	127	Muhammad Umar	Technical Associate	2022-06-27
129	128	Muhammad Farooq Yasin	Executive- QA	2023-11-23
130	129	Muhammad Talha Shehroz	Supervisor - Deployment	2024-02-15
131	130	Hamza Zulfiqar	Executive - Deployment	2024-01-29
132	131	Muhammad Ahsan	Splicer	2022-08-18
133	132	Muhammad Qasim	Supervisior - QA	2024-02-03
134	133	Hammad Ahmad	Technical Associate	2022-09-05
135	134	Abdul Rehman	Technical Associate	2022-09-08
136	135	Muhammad Usman Hader	Associate Network Technician	2022-09-13
137	136	Fakhara Chaudhary	Technical Support Associate	2022-09-15
138	137	Ali Sanwal	Associate Network Technician	2022-09-08
139	138	Ali Raza	Driver	2022-09-29
140	139	Imran Karamat	Driver	2022-09-29
141	140	Muhammad Babar	Technical Assistant	2022-09-30
142	141	Bilal Butt	Driver	2022-10-07
143	142	Farrukh Ehsan Baig	Driver	2022-10-12
144	143	Shaharyar Zulfiqar Ali	Network Technician	2022-10-25
145	144	Adal Waqar	Technical Associate	2022-11-07
146	145	Muhammad Ibrar	Technical Associate	2022-11-07
147	146	Sikandar Abbas	Network Technician	2022-11-15
148	147	Muhammad Usama Tanvir	Technical Support Associate	2022-11-25
149	148	Muhammad Hassan	Splicer	2022-12-08
150	149	Hamza Naveed	Associate Network Technician	2022-12-09
151	150	Adil Tabassum	Driver	2022-12-08
152	151	Hafiz Muhammad Muneeb Ahmad	Team Lead - Deployment	2024-01-29
153	152	Areeb Ahmad	Technical Support Associate	2023-01-13
154	153	Muhammad Ahmad Arshad	Network Technician	2024-02-01
155	154	Syed Faizan Ali	Technical Associate	2023-02-06
156	155	Abu Bakar Siddique	Supervisor - Deployment	2024-01-29
157	156	Muhammad Arslan	Technical Associate	2023-02-20
158	157	Muhammad Imran	Splicer	2023-03-02
159	158	Muhammad Usman	Supervisor - Deployment	2024-02-01
160	159	Fasih Ur Rehman	Executive- QA	2023-11-14
161	160	Ghulam Murtaza	Supervisior - QA	2023-03-24
162	161	Kashif Iqbal	GIS Surveyor	2023-03-27
163	162	Hamza Jamal Pasha	Associate Network Technician	2023-03-30
164	163	Aftab Ahmad	Executive - Deployment	2024-01-16
165	164	Muhammad Zeeshan Iqbal	Supervisor - Deployment	2024-03-05
166	165	Asad Ali	Supervisior - QA	2024-01-16
167	166	Hussam Ahmad	Executive - Deployment	2024-01-16
168	167	Usman Ahmad	Supervisor - Deployment	2024-02-01
169	168	Uzair Qasim	Technical Associate	2023-06-23
170	169	Nadeem Ahmad	Supervisor - Deployment	2024-01-29
171	170	Nadeem Ijaz	Supervisior - QA	2023-08-21
172	171	Muhammad Shafiq	Technician - Deployment	2023-07-25
173	172	Inam Ul Mustafa	Technical Associate	2022-08-01
174	173	Muhammad Kashif	Manager - Fiber Operations	2023-08-21
175	174	Rana Muhammad Mubeen Ud Din	Driver	2023-08-30
176	175	Muhammad Bilal Fareed	Driver	2023-08-30
177	176	Sheikh Muhammad Hamza	Driver	2023-08-31
178	177	Syed Asad Ali	Associate Network Technician	2023-08-05
179	178	Muhammad Ali Raza	Executive- QA	2024-02-01
180	179	Haris Usman	Supervisior - QA	2023-09-11
181	180	Abhishik Danish	Technical Assistant	2023-09-18
182	181	Abdul Qadeer	Supervisor - Deployment	2024-02-06
183	182	Muhammad Ashar Anjum	Supervisior - QA	2024-02-20
184	183	Talha Naveed	Associate Network Technician	2023-09-20
185	184	Fasir Nazir	Associate Network Technician	2023-10-02
186	185	Aqeel Ahmed	Splicer	2023-10-06
187	186	Muhammad Yasir	Technician - Deployment	2023-12-06
188	187	Shehroz Yameen	Splicer	2023-10-06
189	188	Muhammad Abbas	Supervisor- Deployment	2024-02-15
190	189	Khawaja Shaheryar Ahmad	Supervisior - QA	2024-02-01
191	190	Muhammad Ahmad Majid	Executive- QA	2023-10-31
192	191	Faraz Bajwa	Supervisior - QA	2024-02-20
193	192	Arslan Ahmad	Associate Network Technician	2023-10-10
194	193	Muhammad Adnan	Driver	2023-10-23
195	194	Raheel Ahmad	AC Technician	2023-11-03
196	195	Muhammad Faizan	Technician - Deployment	2023-11-23
197	196	Subhan Ali	Technician - Deployment	2023-11-23
198	197	Abdullah Pervaiz	Technician - Deployment	2023-11-29
199	198	Muhammad Ahmad Hassan Bhatti	Sr. Network Technician	2023-11-30
200	199	Usama Iqbal	Technical Support Associate	2023-11-30
201	200	Irtiza Ali	Rigger	2023-11-30
202	201	Amir Shahzad	Technical Support Associate	2023-11-30
203	202	Hafiz Habib Ullah	Splicer	2023-12-05
204	203	Adeel Ahmad Khan	Executive - Planning	2023-11-23
205	204	Abdul Qayyum	Manager - QA	2023-11-23
206	205	Shraf Riaz	Supervisior - QA	2023-12-08
207	206	Muhammad Usama Mubarak	Supervisior - QA	2023-12-12
208	207	Fahad Arshad	Technical Support Representative	2023-12-18
209	208	Hasnain Ali Shah	Technical Associate	2023-12-18
210	209	Muhammad Husnain	Associate Network Technician	2024-01-03
211	210	Syed Hassan Raza	Technician - Deployment	2024-01-08
212	211	Abdullah Ahmad	Technician - Deployment	2024-01-12
213	212	Abdul Wasiq	Supervisior - QA	2024-01-17
214	213	Shabir Hussain	Splicer	2024-01-18
215	214	Shoukat Ali	Rigger	2024-01-18
216	215	Ziam Ahmad	Supervisior - QA	2024-01-18
217	216	Shahzaib Ali	Supervisior - QA	2024-01-22
218	217	Nauman Abid Chaudhary	Executive- QA	2024-01-16
219	218	Muhammad Daniyal Badar	Executive- QA	2024-01-17
220	219	Rana Ali Hamza	Executive- QA	2024-01-17
221	220	Muhammad Fazeel	Supervisior - QA	2024-01-25
222	221	Kashif Khan	Technician - Deployment	2024-01-30
223	222	Muhammad Moazam Sardar	Technician - Deployment	2024-01-30
224	223	Hamza Ali	Technician - Deployment	2024-01-30
225	224	Sohaim Saleem	Technician - Deployment	2024-01-30
226	225	Abdur Rehman	Technical Support Associate	2024-01-29
227	226	Jahanzaib	Supervisor - Deployment	2024-01-29
228	227	Muhammad Usman	Supervisor - Deployment	2024-01-29
229	228	Ali Imran	Supervisor - Deployment	2024-02-15
230	229	Muhammad Awais Ali	Technician - Deployment	2024-01-29
231	230	Furqan Hameed	Supervisor - Deployment	2024-01-29
232	231	Adnan Saeed	Manager - Deployment	2024-01-29
233	232	Adnan Ali	Team Lead - Deployment	2024-01-29
234	233	Muhammad Saifullah Khalid	Technician - Deployment	2024-01-29
235	234	Umair Farooq	Executive - Deployment	2024-01-29
236	235	Mudasir Iqbal	Team Lead - Deployment	2024-02-01
237	236	Abdul Aleem	Supervisor - Deployment	2024-02-01
238	237	Zimad Nazir	Supervisor - Deployment	2024-01-30
239	238	Muhammad Tayyab	Executive - Deployment	2024-01-30
240	239	Syed Farhan Hassan Bukhari	Technician - Deployment	2024-02-01
241	240	Muhammad Ali	Team Lead - Deployment	2024-02-01
242	241	Imran Malik	Team Lead - Deployment	2024-01-31
243	242	Muhammad Atif Ur Rehman	Supervisor - Deployment	2024-02-01
244	243	Shahab Khan	Supervisor - Deployment	2024-02-05
245	244	Roshnan Ali	Supervisor - Deployment	2024-02-02
246	245	Mateen Ahmad	Supervisor - Deployment	2024-02-01
247	246	Mehran Shahid	Team Lead - Deployment	2024-01-31
248	247	Wajeeh Ul Hassan	Technician - Deployment	2024-01-31
249	248	Bilal Zagham	Supervisor - Deployment	2024-01-31
250	249	Ali Raza Ifthikhar	Technician - Deployment	2024-01-31
251	250	Hamza Malik	Technician - Deployment	2024-01-31
252	251	Muhammad Farhan Shehzad	Technician - Deployment	2024-02-06
253	252	Muhammad Zohaib	Technician - Deployment	2024-02-07
254	253	Muhammad Danyal	Technician - Deployment	2024-02-07
255	254	Mansoor Ahmed Khan	Executive- QA	2024-02-12
256	255	Hafiz Usman Farrukh	Supervisior - QA	2024-02-19
257	256	Zeeshan Ul Haque	Manager - Deployment	2024-03-01
258	257	Ali Haider	Supervisior - QA	2024-02-14
259	258	Sarfraz Ahmad	Supervisior - QA	2024-02-26
260	259	Faisal Ashraf	Technician - Deployment	2024-02-14
261	260	Muhammad Asad Ehsan	Supervisior - QA	2024-02-14
262	261	Muhammad Mehdi	Supervisior - QA	2024-02-14
263	262	Muhammad Mudassar Akram	Executive- QA	2024-02-13
264	263	Muhammad Bilal Asghar	Supervisior - QA	2024-02-14
265	264	Nouman Bashir	Supervisor - Deployment	2024-03-04
266	265	Jawad Hassan	Executive- QA	2024-03-01
267	266	Muhammad Zeeshan	Team Lead - Deployment	2024-02-19
268	267	Muhammad Abrar	Team Lead - Deployment	2024-02-19
269	268	Abdullah Sajid	Executive - Deployment	2024-02-14
270	269	Muhammad Shazil Asif Attari	Supervisior - QA	2024-02-14
271	270	Ikram Hussain	Supervisor - Field Operations	2024-03-01
272	271	Sanif Ur Rehman	Supervisior - QA	2024-02-13
273	272	Haris Nazir	Supervisior - QA	2024-02-13
274	273	Ghazanfar Gulzar	Supervisor - Deployment	2024-02-21
275	274	Hafiz Amaz Ali	Technician - Deployment	2024-02-21
276	275	Ahmar Ahtisham	Technician - Deployment	2024-02-21
277	276	Mahad Ali Khan	Executive - Deployment	2024-02-21
278	277	Junaid Ahmed	Manager - Deployment	2024-02-21
279	278	Farhan Bashir	Manager - Fiber Operations	2024-03-26
280	279	Nadeem Abbas	Technician - Deployment	2024-02-23
281	280	Haseeb Ashfaq Khan	Technician - Deployment	2024-02-29
282	281	Muhammad Adeel	Technical Associate	2024-02-29
283	282	Muhammad Zeeshan Ali	Executive - Deployment	2024-03-04
284	283	Muhammad Fahad Malik	Network Technician	2024-02-01
285	284	Muhammad Athar Rana	Executive - Deployment	2024-03-12
286	285	Wasim Akram	Technician - Deployment	2024-04-08
287	286	Muhammad Azeem	Associate Network Technician	2024-04-19
288	287	Muhammad Zeeshan	Technical Associate	2024-04-23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:F289	Expression	=ISNUMBER(MATCH($C3,$G$2:$G$65,0))	text	NO
A2:F2	Expression	=ISNUMBER(MATCH($C2,$G$2:$G$65,0))	text	NO

 

[AFZAL SOHAIL]

Thanks a lot for your reply Sir,
Actually i want to trace out the entry of Col-B is present in Col-F or not.
For example in B2 Hafiz Hussain Ahmad is in the list of F or not, if it present then highlight it

 

[awoohaw]

then use this formula as your conditional formatting rule.

=ISNUMBER(MATCH($B2,$F$2:$F$65,0))

 

[AFZAL SOHAIL]

Sir, I applied this formula but nothing happened through conditional formatting.

 

[awoohaw]

Sir, I applied this formula but nothing happened through conditional formatting.

works for me:

Book1
	A	B	C	D	E	F	G
1	SR.NO.	Name	Position	Joining Date	Sr.No.	Name	Designation
2	1	Hafiz Hussain Ahmad	Network Technician	2024-01-08	1	Zulfiqar Ali	Associate Network Technician
3	2	Hafiz M Babar Ishaq	Supervisor - Deployment	2024-02-29	2	muhammad Arif Anjum	Associate Network Technician
4	3	Basit Aziz Ullah	Executive - Deployment	2024-01-29	3	Muhammad Ilyas	Associate Network Technician
5	4	Muhammad Suleman	Supervisor - Deployment	2024-02-13	4	RAI M Zergham KHAN	Associate Network Technician
6	5	Hamid Maqbool	Sr. Network Technician	2019-04-23	5	Muhammad Tariq Hanif	Associate Network Technician
7	6	Syed Ali Raza	Supervisior - QA	2024-02-20	6	Abdul Hannan Ali	Associate Network Technician
8	7	Mehmood Ali Khalid	Supervisor - Field Operations	2024-02-01	7	Muhammad Daud Malik	Associate Network Technician
9	8	Wali Ur Rehman	Network Technician	2015-05-21	8	Ali Sanwal	Associate Network Technician
10	9	Shahid Nazir	Rigger	2016-01-01	9	Syed Asad Ali	Associate Network Technician
11	10	Muhammad Haseeb Javed	Supervisor - Deployment	2024-02-01	10	Talha Naveed	Associate Network Technician
12	11	Muhammad Hamza Javed	Team Lead - Deployment	2024-01-29	11	Arslan Ahmad	Associate Network Technician
13	12	Abdullah Raza	Technical Support Associate	2022-12-07	12	Muhammad Husnain	Associate Network Technician
14	13	Muhammad Kamran	Sr. Network Technician	2024-02-01	13	Muhammad Asim	Driver
15	14	Aon Muhammad	Splicer	2017-02-03	14	Muhammad Shafiq	Driver
16	15	Azhar Ali	Supervisor - Field Operations	2024-02-01	15	Imran Ahmed	Driver
17	16	Umair Chaudhry	Splicer	2024-02-01	16	Muhammad Amin shahid	Driver
18	17	Adnan Majeed	Technical Associate	2017-02-03	17	Nasir Arfat	Driver
19	18	Muhammad Ibrahim	Driver	2017-02-03	18	Hafiz Muhammad Imtiaz	Driver
20	19	Muhammad Riaz	Technical Assistant	2017-03-21	19	Ali Raza	Driver
21	20	Muhammad Asim	Driver	2020-03-18	20	Imran Karamat	Driver
22	21	Muhammad Shafiq	Driver	2017-03-21	21	Rana Muhammad Mubeen Ud Din	Driver
23	22	Zulfiqar Ali	Associate Network Technician	2017-03-21	22	Muhammad Adnan	Driver
24	23	Haris Lateef	Sr. Technical Support Representative	2023-11-03	23	Muhammad Kashif	Manager - Fiber Operations
25	24	Haris Naveed	Network Technician	2017-06-08	24	Hassan Ali	Network Technician
26	25	Imran Ahmed	Driver	2017-07-17	25	Aon Muhammad	Splicer
27	26	Muhammad Amin shahid	Driver	2017-07-18	26	Muhammad Irfan	Splicer
28	27	Vikram Javed	Sr. Rigger	2022-05-24	27	Yasir Ali	Splicer
29	28	Muhammad Usama Habib	Team Lead - Deployment	2024-02-02	28	Muhammad Sajjad	Splicer
30	29	Sajjad Ali	Associate Network Technician	2017-08-18	29	Muhmmad Faizan	Splicer
31	30	Hafiz Atif	Supervisior - QA	2024-02-21	30	Muhammad Asim Shahzad	Splicer
32	31	Hafiz Waseem Iqbal	Sr. Splicer	2018-05-04	31	Muhammad Ahsan	Splicer
33	32	Faisal Maqsood	Technical Assistant	2017-07-19	32	Muhammad Imran	Splicer
34	33	muhammad Arif Anjum	Associate Network Technician	2017-07-19	33	Hafiz Habib Ullah	Splicer
35	34	Muhammad Asim	Technical Associate	2017-10-03	34	Shabir Hussain	Splicer
36	35	Muhammad Adil Jahangir	Technical Associate	2017-10-03	35	Khalid Ali	Sr. Splicer
37	36	Ramis James	Sr. Rigger	2018-05-09	36	Mehmood Ali Khalid	Supervisor - Field Operations
38	37	Farhan Khursheed	Sr. Rigger	2018-05-09	37	Ikram Hussain	Supervisor - Field Operations
39	38	Muhammad Anwar Ishaq	Sr. Rigger	2018-09-10	38	Faisal Maqsood	Technical Assistant
40	39	Salman Shahzad	Supervisior - QA	2024-02-20	39	Muhammad Arslan	Technical Assistant
41	40	Salman Mukhtar	Technical Assistant	2019-01-12	40	Muhammad Nadeem	Technical Assistant
42	41	Muhammad Arslan	Technical Assistant	2019-01-12	41	Muhammad Akmal	Technical Assistant
43	42	Muhammad Nadeem	Technical Assistant	2019-01-12	42	Muhammad Babar	Technical Assistant
44	43	Hassan Ali	Network Technician	2019-04-18	43	Abhishik Danish	Technical Assistant
45	44	Muhammad Gulfam Tariq	Supervisior - QA	2024-02-13	44	Muhammad Asim	Technical Associate
46	45	Muhammad Kashif	Supervisor - Field Operations	2024-02-01	45	Muhammad Adil Jahangir	Technical Associate
47	46	Muhammad Aftab Hanif	Network Technician	2019-04-25	46	Sami Ullah	Technical Associate
48	47	Mirza Safwan Baig	Sr. Network Technician	2019-04-18	47	Hasnain Ghani	Technical Associate
49	48	Nasir Arfat	Driver	2019-05-29	48	Waheed Mahmood	Technical Associate
50	49	Muhammad Usman Mahmood	Sr. Network Technician	2019-06-10	49	Ali Hira	Technical Associate
51	50	Ibtasam Afzal	Splicer	2023-05-11	50	Syed Ali Murtaza	Technical Associate
52	51	Suleman Khalil	Rigger	2019-07-26	51	Muhammad Azhar Saroosh Naqeeb	Technical Associate
53	52	Muhammad Akmal	Technical Assistant	2019-09-04	52	Muhammad Umar	Technical Associate
54	53	Muhammad Irfan	Splicer	2019-09-04	53	Muhammad Arslan	Technical Associate
55	54	Danish Masih	Technical Associate	2019-09-04	54	Muhammad Noman	Technical Associate
56	55	Muhammad Ilyas	Associate Network Technician	2019-09-16	55	Uzair Qasim	Technical Associate
57	56	Yasir Ali	Splicer	2019-09-19	56	Inam Ul Mustafa	Technical Associate
58	57	Muhammad Hamza	Team Lead- Deployment	2024-02-01	57	Muhammad Adeel	Technical Associate
59	58	Muhammad Ans Irfan	Manager - Deployment	2023-08-21	58	Hassan Maqsood	Technical Associate
60	59	Sami Ullah	Technical Associate	2020-03-13	59	Dawood Ali	Technical Associate
61	60	Adeel Nazeer	Technical Associate	2020-01-01	60	Aneeq Ahmad	Technical Associate
62	61	Muhammad Hasnain	Associate Network Technician	2023-10-09	61	Farrukh Ehsan Baig	Driver
63	62	Zeeshan Ahmad	Technical Associate	2020-01-01	62	Muhammad Hussain Hani	Power Technician
64	63	Waqas Ilyas	Driver	2020-01-01	63	Irtiza Ali	Rigger
65	64	Haider Ali	Driver	2020-01-01	64	Farhan Bashir	Manager - Fiber Operations
66	65	Mohsin Mujtaba	Driver	2020-01-21
67	66	Daud	Splicer	2024-01-30
68	67	Arbab Ahmad	Associate Network Technician	2023-12-08
69	68	Muhammad Sajjad	Splicer	2020-02-17
70	69	Hasnain Ghani	Technical Associate	2020-02-21
71	70	RAI M Zergham KHAN	Associate Network Technician	2020-05-20
72	71	Ghulam Abbas	Associate Network Technician	2020-06-09
73	72	Muhammad Muzaib Manzoor	Associate Network Technician	2020-06-09
74	73	Mujahid Ali	Associate Network Technician	2020-06-09
75	74	Muhammad Bilal	Associate Network Technician	2020-06-09
76	75	Muhammad Hussain Hani	Power Technician	2020-06-08
77	76	Raza Haider	Associate Power Technician	2020-06-08
78	77	Noor Ahmad	Network Technician	2020-06-08
79	78	Ijaz Ahmad	Network Technician	2020-06-08
80	79	Shahzad Shafique	Driver	2020-08-24
81	80	Hassan Maqsood	Technical Associate	2020-10-08
82	81	Muhammad Waqas	Technical Associate	2020-10-08
83	82	Muhammad Naeem	Technical Associate	2020-10-20
84	83	Muhammad Usman	Technical Associate	2020-11-11
85	84	Muhammad Muneeb Ur Rehman	Network Technician	2024-02-01
86	85	Ramzan Shah	Technical Associate	2021-06-21
87	86	Rashid Arshad Ali	Splicer	2021-06-07
88	87	Muhammad Saeed Khan	Driver	2021-05-18
89	88	Waheed Mahmood	Technical Associate	2021-07-23
90	89	Hafiz Muhammad Imtiaz	Driver	2021-07-29
91	90	Abdullah Khalil	Executive - Deployment	2024-02-21
92	91	Muhammad Tariq Hanif	Associate Network Technician	2021-09-13
93	92	Muhammad Naeem Ansari	Supervisor - Deployment	2024-02-13
94	93	Abdul Hannan Ali	Associate Network Technician	2021-09-28
95	94	Adeel Abbas	Supervisior - QA	2024-02-21
96	95	Malik Arham Jaa	Supervisior - QA	2024-02-20
97	96	Faiz ur Rehman	Supervisior - QA	2024-02-21
98	97	Muhammad Tayyab	Supervisor - Deployment	2024-01-29
99	98	Syed Muhammad Mehdi	Technical Associate	2021-12-08
100	99	Muhammad Hussnain	Associate Network Technician	2021-12-08
101	100	Rehan Ali	Technical Support Associate	2022-02-15
102	101	Muhammad Bilal Ahmad	Network Technician	2022-02-07
103	102	Muhmmad Faizan	Splicer	2022-03-07
104	103	Saghir Ahmed Bhatti	Technical Associate	2022-02-23
105	104	Shahid Shoaib	Technical Associate	2022-02-23
106	105	Amir Munir	Splicer	2022-02-23
107	106	Muhammad Daud Malik	Associate Network Technician	2022-03-25
108	107	Muhammad Nasir	Executive - Deployment	2024-01-29
109	108	Ali Hira	Technical Associate	2022-04-21
110	109	Muhammad Asim Shahzad	Splicer	2024-03-01
111	110	Syed Ali Murtaza	Technical Associate	2022-04-21
112	111	Muhammad Zia Ullah	Executive - Fiber Operations	2024-04-03
113	112	Umair Nawaz	Team Lead - Deployment	2024-01-29
114	113	Muhammad John Raza	Supervisior - QA	2022-05-06
115	114	M Ahsan Ahmed Siddiqui	Technician - Deployment	2022-04-29
116	115	Muhammad Shoaib	Manager - Deployment	2024-04-01
117	116	Muhammad Hamza Shahid	Supervisior - QA	2024-02-06
118	117	Ahsan Jamil	Team Lead - Deployment	2024-01-29
119	118	Maqsood Shahzad	Supervisior - QA	2022-05-06
120	119	Usama Abid	Supervisior - QA	2022-05-10
121	120	Muhammad Shahzaib	Technical Associate	2022-04-16
122	121	Dawood Ali	Technical Associate	2022-04-20
123	122	Aneeq Ahmad	Technical Associate	2022-04-20
124	123	Asif Ali	Supervisior - QA	2022-05-10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E2,A2:D288	Expression	=ISNUMBER(MATCH($B2,$F$2:$F$65,0))	text	NO

 

[AFZAL SOHAIL]

Thanks a lot Sir,
It is working now through conditional formatting, before I select the wrong, I correct it is working now.
If I match Col-b with Col-F then what would the formula, not necessary to highlight need a formula.

 

[awoohaw]

the match function gives you the row number (relative to the top of the search range) in the search range column.

=MATCH($B2,$F$2:$F$65,0)

 

[AFZAL SOHAIL]

Thanks a lot Sir,it is working and giving the row number, so possible give the employee name ?

 

[awoohaw]

Thanks a lot Sir,it is working and giving the row number, so possible give the employee name ?

This may work for 2021 excel, but unsure:

=XLOOKUP($B2,$F$2:$F$65,$F$2:$F$65,0)

If it does not work in 2021

 =INDEX($F$2:$F$65, MATCH($B2,$F$2:$F$65,0))

NOTE: I am really confused why you want to use the name to look up the name? You already have the name because it is your search criteria.