The formula for the conditional formatting in E2 will be

or(sum(E4:E20)>816,sum(E5:E21)>816,sum(E6:E22)>816)

Then copy this to cell g2 etc.
(might be easier to just use the extend handle and then replace what you
wanted in the intervening cells.)

or you could use

Max(sum(E4:E20),sum(E5:E21),sum(E6:E22))>816

It could also be done by VBA using a for loop which would avoid having to plug
in all the separate ranges (what is the last one for col E?)

Or you could write a vba fiunction and use that in the conditional format.
That is probably the method I would use if there were many ranges.