Conditional formatting with multiple criteria

[floribunda]

I am trying to do a conditional formatting based on the result in one cell but it needs to add up multiple cells first to determine which conditional format it needs to use. I am not sure whether I need to do a formula conditional format or whether to use cell is greater than with =sum() in it. I have tried both but neither seem to be working correctly.
I have attached an example of the spreadsheet and the conditions I am trying. I am using 2010 version.

Basically, the closing amount for Monday in prod 1 (cell c4), needs to display in red if sum of the cumm value for Tuesday (L4), Wed (N4), Thur (P4) & Fri (R4) is greater than that value or display in amber if the sum of the cumm value for Tuesday (L4), Wed (N4), Thur (P4).

I need to complete the same for the whole column for Monday (col C) for each appropriate product. Then the same for column B but this will sum different cells but the principal will be the same.

Any help on this would be great as I am stuck!
Thanks.

[martindwilson]

or display in amber if the sum of the cumm value for Tuesday (L4), Wed (N4), Thur (P4).

if the sum is what?
first bit is =SUM($L4,$N4,$P4,$R4)>$C4

[Fotis1991]

C5=0. Then your formula for amber(as first condition) is =SUM($L4,$N4,$P4). This Sum gives 20. So correctly the color in this cell is aber..

[floribunda]

if the sum is what?
first bit is =SUM($L4,$N4,$P4,$R4)>$C4

Sorry I didn't make myself very clear
The amber section would be the =sum($L4,$N4,$P4)>$C4. So more or less the same formula just one cell less.