Laurie, another reason for conditional formatting to not work, is the right order of the rules applied... In your case, the "red" rule must be first in your "rules order". When this happends, go to manage rules, and move up the rule which is not working.
Good luck..