Thanks!

I've actually reverted to simply using a COUNTIF function for the thresholds. It's a little more convoluted I suppose but it works. Unfortunately, my greatest area of concern is identifying whether changes occurred after 48hours (2 consecutive cells) or 3 days (3 consecutive cells) - any advice?