Excel help (snore)

[spellmanuk]

So I'm a scout leader and each week the scouts are marked on how smart there uniform is and if they turn up on time for the scout of the year competition, I have an excel spreadsheet to store this I wanted some help with making it auto add up the score for each kid and if possible auto colour code each score (e.g. Red for 0-4 amber for 5-7 and green for 8-10) I know that the auto adding up is possible I just forgot how to do it is there a way to auto colour code cells though? 

[BlueChinchillaEatingDorito]

To add up scores, just use =sum(x:y)

 

Where x is the cell you want to start summing and y is the last cell.

[ARikozuM]

https://support.office.com/en-us/article/Apply-conditional-formatting-with-color-in-Excel-34402f91-c7e7-4060-944c-65d913033d18

[spellmanuk]

54 minutes ago, BlueChinchillaEatingDorito said:

To add up scores, just use =sum(x:y)

 

Where x is the cell you want to start summing and y is the last cell.

 

51 minutes ago, ARikozuM said:

https://support.office.com/en-us/article/Apply-conditional-formatting-with-color-in-Excel-34402f91-c7e7-4060-944c-65d913033d18

cheers guys