Conditional Formatting if 2 cell match

[Vod0]

Trying to get a row to become green/red if it matches 2 cells in another row, to confirm if its present or not in the other sheets.

If there is a match in Table 1 or 2 that is equal to A4 and E4, then I want A4:F4 to turn green, Table 1 and 2 retrieve data from other sheets in the same Excel document and are to be used to confirm that what appears in the table A:F has been added to the various tables. G4 was another attempt to run an Index Match formal that returned "True/False" to then be able to do Conditional formatting based on that value but didn't get it to work.

Table 1 and 2 are exactly the same, only I tried to find out which direction I needed to have for it to work.

 

[Vod0]

Would like it to be like this:
(It cant find E6 in table 1/2, dosent need the "MISSING" text)

 

[Vod0]

Found a solution.

=IF(AND(A4=$Q$4),MATCH(E4,$R$4:$CT$4,0))

(x 7, one for each day)