Selected Answer
Hi and welcome to the Forum.
Yes conditional formatting can do that (if I understand you correctly).
In the attached revised file, I've applied the following method top cells C16 to F18 (only). Here's how...
Firstly select cell C16 then go menu Home, ribbon Styles and click Conditional Formatting/ New Rule... then Use a formula...
Under Format values... paste:
=If(sum(C$16:C$18)>0.75,1,0)
Click Format... then choose the Fill tab and pick a red, click OK.
In New Formatting... requestor, click OK
Click Apply and you'll see that his only affects C16 - you'll see that rule "Applies to" =$C$16. Change that to =$C$16:$C$18 (being careful since Excel guesses the range) then click Apply- you'll see it now affects C16 to C18.
Now (with that rule selected) click the Duplicate Rule button twice then select each new rule and use the Edit Rule... button to edit the formula and replace >0.75 with >=50 and choose yellow then on the last rule with <0.50 and choose green..
The "red" rule should be at the top (since that overwrites the rules below) then the yellow then the green.
You can then copy that format to other cells in those rows.
Change the values in a week and the fill colour will change to suit (I've just changed single cells to check)..
To copy the format to other rows, you'll need to edit the formula to replace the bold bit in:
=If(sum(C$16:C$18)>0.75,1,0)
to address the new rows. Then copy over those the same rows as belore.
Hope this fixes your problem. If so, please don't forget to mark this answer as Selected.
