There are two variants of the CASE expression: the simple CASE expression and the searched CASE expression. You are mixing the two.

When using the simple CASE expression, the comparison is always "equal". Since you need to use ranges, you cannot use the simple CASE expression.

Drew