Conditional Formatting over multiple cells

Hello everyone.

I'm generating a user worksheet that must keep our users from exceeding certain values over multiple line items.

Basically each item has a line, but multiple items can fall into the same "category" and when taken individually and or added together must not exceed a specific value.

So if lines 1,2,5 and 9, all added together, and/or if one of the lines alone, exceed a specific value, the numbers all turn red to warn the user that they've exceeded their qty available.

Any help would be greatly appreciated.