Conditional formatting with OR and INDIRECT functions not working

Hello to all,

I encountered this problem by chance and can't for the life of me figure out why it isn't working. A full explanation is given in the attached workbook, however, I will give some context.
I want to apply conditional formatting on 4 cells if one of the 4 cells is a certain value, I want to do this for cell A1:A4, the to A5:A8 and so on.

This is only a small part of the explanation of what I want and of what the problem is, the attached excel workbook explains everything in full.
I sincerely hope someone can help me with this.

Forum_Question-Conditional formatting with OR and INDIRECT.xlsx

Kind Regards,

Noah Disseldorp