Unable to refer another spreadsheet value using INDIRECT in Google Sheet inside regexmatch

Question

I want to highlight rows of Sheet-1 whose column C has similar values of sheet-2 column 'A'. I have tried using the following expression one by one on custom formula through Format-conditional formatting. but none of them are giving the result as expected.

=REGEXMATCH($C2, INDIRECT("disposable-emails!A1"))
=FILTER(C2, COUNTIF(INDIRECT("disposable-emails!A1:A"),C2))
=FILTER(C2, COUNTIF(INDIRECT("disposable-emails!A1:A"),"*"&C2&"*"))
=REGEXMATCH(C2, TEXTJOIN("|",1,INDIRECT("disposable-emails!A1:A")))

and Unfortunately, this also didn't worked:

=IF(IFERROR(REGEXEXTRACT(C2, TEXTJOIN("|", 1, INDIRECT("'disposable-emails'!A1:A"))))<>"",1)

So I am sharing you both sheet link these are editable:

Sheet-2: disposable-emails

Click here to see Sheet-2 disposable-emails

Sheet-1: WebMessages

Click here to see Sheet-1 webmessages

IMPORTANT: I want the entire row to be highlighted based on matching column value (not only the column cell but the entire row of that cell).

Apart from my main query, there is another formatting rule that is, if a bot-state column has any value (not blank) then highlight that entire row (not only the column cell but the entire row of that cell). You have to select the bot-state column to see 2nd rule

Answer 1

this has nothing to do with INDIRECT function if you have 2 separate spreadsheets. merge your Sheet1 and Sheet2 under one spreadsheet and do:

=IF(IFERROR(REGEXEXTRACT(C2, TEXTJOIN("|", 1, 
 INDIRECT("'disposable-emails'!A1:A"))))<>"",1)

spreadsheet demo