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