Conditional Format applied sum to columns.

Hi all!
I started doing this and inputting the individual cells but I think I'd be an old man by the time I'd finished sooo....
The formula / sum is;
Not between- B (eg;1.000)+ C (eg;+0.005) / B (eg;1.000)+D(eg;-0.005) will return figures in RED.

I need to apply this to columns E-I

On each row "B" could be a different figure.

How do I apply this to columns instead of doing;
Cell value - Not between - =B2+C2 and B2+D2
Cell value - Not between - =B3+C3 and B3+D3
etc x10000!

I've played with this with no success!

Sample attached.

Thanks Olly!
It was the =$E:$I bit that i'd have never guessed!

Works a treat now.

Regards,Mark.