How to make it Highlight in Any color while selecting the name

[Nixson]

Sir,

Good day!!!


I want to select table 2 Name and need to any color highlights showing their leave plan in first table.

Kindly help me.

Table 1

S.NO	NAME OF EMPLOYEE	JAN 2025	FEB 2025	MAR 2025	Apr-25	May-25	Jun-25	Total
1	Vinny Johnson				3	28		31
2	Blessina Bosco		7			6	17	30
3	Sachin More			14				14
4	Nixson John		5	23				28
5	Sameeksha				6	6		26
6	Siddharth Kashyap				21			21
7	Abhijith Shridhar Bhatgave				3	11		26
	Total	0	12	37	33	51	17

Annual Leave History - Table 2
Employee name	Start Date	End Date	Leave Type	No. of days
Vinny Johnson	28-Apr-25	28-May-25	Vacation	31
Blessina Bosco	10-Feb-25	16-Feb-25	Vacation	7
Sachin More	11-Mar-25	24-Mar-25	Vacation	14
Nixson John	24-Feb-25	23-Mar-25	Vacation	28
Sameeksha	26-Mar-25	6-Apr-25	Vacation	12
Siddharth Kashyap	7-Apr-25	27-Apr-25	Vacation	21
Abhijith Shridhar Bhatgave	28-Apr-25	11-May-25	Vacation	14
Blessina Bosco	26-May-25	17-Jun-25	Vacation	23
Sameeksha	10-Aug-25	23-Aug-25	Vacation	14
Abhijith Shridhar Bhatgave	10-Nov-25	21-Nov-25	Vacation	12

 

[DanteAmor]

Check if this is what you need.

For example, select cell B4 (Blessina Bosco), automatically, the cells of table2 are highlighted in yellow.

​

Or select cell A20 (Sameeksha) and the cell in table1 is automatically selected.

Try:

varios 29ene2025.xlsm
	A	B	C	D	E	F	G	H	I
1
2	S.NO	NAME OF EMPLOYEE	ene-25	feb-25	mar-25	abr-25	may-25	jun-25	Total
3	1	Vinny Johnson				3	28		31
4	2	Blessina Bosco		7			6	17	30
5	3	Sachin More			14				14
6	4	Nixson John		5	23				28
7	5	Sameeksha				6	6		26
8	6	Siddharth Kashyap				21			21
9	7	Abhijith Shridhar Bhatgave				3	11		26
10		Total	0	12	37	33	51	17
11
12
13
14	Annual Leave History - Table 2
15	Employee name	Start Date	End Date	Leave Type	No. of days
16	Vinny Johnson	28-abr-25	28-may-25	Vacation	31
17	Blessina Bosco	10-feb-25	16-feb-25	Vacation	7
18	Sachin More	11-mar-25	24-mar-25	Vacation	14
19	Nixson John	24-feb-25	23-mar-25	Vacation	28
20	Sameeksha	26-mar-25	06-abr-25	Vacation	12
21	Siddharth Kashyap	07-abr-25	27-abr-25	Vacation	21
22	Abhijith Shridhar Bhatgave	28-abr-25	11-may-25	Vacation	14
23	Blessina Bosco	26-may-25	17-jun-25	Vacation	23
24	Sameeksha	10-ago-25	23-ago-25	Vacation	14
25	Abhijith Shridhar Bhatgave	10-nov-25	21-nov-25	Vacation	12
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A16:E25	Expression	=$A16=INDIRECT(CELL("address"))	text	NO
A3:I9	Expression	=$B3=INDIRECT(CELL("address"))	text	NO