Compare, Search and highlight

[Vishaal]

Thanks in Advance,

we have the following sheet

Excel 2010 32 bit

	A​	B​	C​
1​
2​		Emma
3​		Olivia
4​		Charlotte
5​		Harper
6​		Scarlet
7​		Charlotte
8​		Ava
9​		Mia
10​		Scarlet
11​		Ava
12​		Charlotte
13​		Olivia
14​

Sheet: Sheet1

We want to following result

Excel 2010 32 bit

	A​	B​	C​
1​
2​		Emma
3​	Harper, Isabella	Olivia
4​		Charlotte
5​		Harper
6​	Isabella, Mia	Scarlet
7​		Charlotte
8​		Ava
9​		Mia
10​	Ava, Amelia	Scarlet
11​		Ava
12​		Charlotte
13​		Olivia
14​

Sheet: Sheet1

in this result, we have checked

1. A3 value in B3 to last row
2. A6 value in B6 to last row
3. A10 value in B10 to last row
4. Any value (name or numerical) anywhere in column we put it start search in column B (same row) and highlight the cell

Pls provide any code or vba or formula

 

[Vishaal]

I have downloaded and checked


Its working

Thanks for your help sir

 

[Vishaal]

Hi, one more request and that is can we get any common text (i mean xyz) on next row of highlighted cell

i mean, check the following sheet

Excel 2010 32 bit

	A​	B​	C​	D​	E​
1​
2​
3​			Emma
4​		Harper, Isabella	Olivia
5​			Charlotte
6​			Isabella	xyz
7​			Harper
8​		Isabella, Mia	Scarlet
9​			Charlotte
10​			Ava
11​			Mia	xyz
12​		Ava, Amelia	Scarlet
13​			Ava	xyz
14​			Charlotte
15​			Olivia
16​

Sheet: Sheet1

sorry

but help pls

 

[Vishaal]

find the solution in forum this in old post

but its added some time and task for me

Thanks Mrexcel