conditional formatting based on collapsed rows

Hi,

I've got some collapsible rows (rows 7:11) that sit underneath rows 6 (which is a summary row). I'm trying to use the following formula in conditional formatting so that if B7 is visible then the conditional formatting doesn't apply and it doesn't colour the cells (the mid shade of blue below):

=IF(SUBTOTAL(103,B7)<>1,AND($C6<=E$2,$D6>=E$2))

The formula works, but for some reason only the first cell (Q3 in 2023) goes blank with this formula rather than the whole row - does anyone know how to fix this?

Thanks in advance!!