Conditional formatting doesn't work....

I've been trying to learn some more "advanced" excel tips and tricks. I input information exactly as described in tutorials, and yet the results that are returned are nonsensical.

For a table where I'm trying to highlight all rows that contain certain information, I go to Conditional Formatting -> New Rule and input: =$B3<$B$2. And it highlights some cells that fit that criteria, but doesn't highlight others. It's very frustrating because this is the same type of thing I'm seeing with all the formulas I'm trying to learn, so I'm trying to see what I'm doing wrong.
I've also tried =$B3<$B2
=$B3<"$B2"
=$B3<10

I've changed the numbers to "text" and back again to "number".
I'm at my wits end. I've attached a file that will hopefully show what I'm talking about.

Please help!