Google Sheets: How Do I Colour A Cell via Using VLOOKUP to iterate through multiple cols of other tabs to find that certain key?

Question

CONTINUE FROM: Google Sheets: How Do I Colour A Cell In 2 Cases Context Based on Values From Another Sheet

I have another Google Sheet that has the same dashboard but instead, this sheet aims to sort hints by Category.

Each sheet will have rows allocated to store both Bonus and Golden Hints (and I have 8 sheets in total).

Still aiming for same behaviour of highlighting cell once the user keys in the hint number in Col B.

Are we still able to use CF to loop thru all 8 sheets, identify the hint # in the appropriate range and the highlight the cell? Or is this now too complex for CF ?

https://docs.google.com/spreadsheets/d/1bLmL6E0odCB4aKBBZWqUeoyEYxKphmInL9wS6lsKQr8/edit?usp=sharing

I have tried the below-mentioned formulas in my Conditional Formatting but to no avail. These are improvised from the help given in Reference Post and also from my own research to my best ability.

Is my request now too complicated for Conditional Formatting?

1. INDEX(VLOOKUP(D8, {ROW(INDIRECT("BONUS!B2:B"))-1, INDIRECT("BONUS!B2:B")}, 2, 0))<>""

2. INDEX(VLOOKUP(D8, {INDIRECT("AREA / SUBZONE!B85:B124")), INDIRECT("SPOT (GENERIC)!B85:B204")}, 1, 0))<>""

3. INDEX( VLOOKUP (D8, { ROW ( INDIRECT(" 'AREA / SUBZONE'!B85:B124") ) }, 2, 0) )<>""

4. "ARRAYFORMULA(IFNA(VLOOKUP(A2:A, {
 INDIRECT(PEOPLE!A2&""!A:F"");
 INDIRECT(PEOPLE!A3&""!A:F"");
 INDIRECT(PEOPLE!A4&""!A:F"");
 INDIRECT(PEOPLE!A5&""!A:F"")}, COLUMN(B:F), 0)))"