Conditional Formatting Not Working

Hmm?

Are you using Excel 2007?

I re-uploaded the file. As mentioned, up above, I added some rows since my original submittal, so cell references in these discussions may not match up.

Other than that, the intent is still the same.