very complicated conditional formating

[lachlanmullen]

for some reason that is applying the conditional format to all selecte
rows EXCEPT for the very bottom one.

Weird

 

[Frank Kabel]

Hi
this is the formula for the first row.