Some of the Conditional Format Rules in 2007 will not move to earlier versions, for example Excel 2007 can have more than 3, however Excel 2003 can only use 3

This is your Formula

=AND($B$4+$B$1:$B$5<0,$A$1:$A$5>0)

It will always be true, so the condition applies.

What are you trying to check?