Unless I'm not understanding what you are trying to do, it seems to be working fine. When D6 is 4, no concatenated cells in row 6 are highlighted. When I change it to 3, all of the 0/4 cells become highlighted. Nothing happens in to the cells in any other row. Likewise if I change the D value in any other row.

Of course, you cannot have the single quotes in the concatenated fields so I'm not quite sure why you still have those.

And you may need to format the concatenated cells as text. Excel might think they are dates.