Conditional Formatting base on Cell result

Please help me to get this result
I have a Large file in excel and am using a formula to return a match value like the one below.

below array formula will return the Data based on the match. with this formula, it will return the Name of People from "AllMasterData" Sheet to "Track Data" Sheet . and i have the company name in the "AllMasterData" of Name of People.

Now I want to highlight the individual cell based on the Company Name in "AllMasterData" which matches with the Name of People.


AllMasterData Sheet.-Sample

1679911430878.png



Track Data Sheet - Result required
Formula Uses
=INDEX(AllMasterData!$AC$4:$AC$1020,SMALL(IF(ISNUMBER(MATCH(AllMasterData!$I$4:$I$1020,BI37,0)),MATCH(ROW(AllMasterData!$I$4:$I$1020),ROW(AllMasterData!$I$4:$I$1020)),""),ROWS($A$1:$A$1)))
=INDEX(AllMasterData!$AC$4:$AC$1020,SMALL(IF(ISNUMBER(MATCH(AllMasterData!$I$4:$I$1020,BI37,0)),MATCH(ROW(AllMasterData!$I$4:$I$1020),ROW(AllMasterData!$I$4:$I$1020)),""),ROWS($A$1:$A$2)))
=INDEX(AllMasterData!$AC$4:$AC$1020,SMALL(IF(ISNUMBER(MATCH(AllMasterData!$I$4:$I$1020,BI37,0)),MATCH(ROW(AllMasterData!$I$4:$I$1020),ROW(AllMasterData!$I$4:$I$1020)),""),ROWS($A$1:$A$3)))
=INDEX(AllMasterData!$AC$4:$AC$1020,SMALL(IF(ISNUMBER(MATCH(AllMasterData!$I$4:$I$1020,BI37,0)),MATCH(ROW(AllMasterData!$I$4:$I$1020),ROW(AllMasterData!$I$4:$I$1020)),""),ROWS($A$1:$A$4)))

1679911498340.png


Thank you

No suitable answer was received, so i posted again here

Thank you

Thank you, Now, I understood the forum rules.

I am trying to post the links but it showing this error

Untitled.png

Ohh, Thanks lot 6StringJazzer,
No More links, still I am expecting a suitable answer to my question. Mr. Excel forum answer does not work for me.

Thank you