How to color cell in column C automatically in a certain color when the cells next to it in colum A and B meet certain conditions? (Excel-VBA) : I would like to programm in excel-VBA the following:

1. In column A and B there will be numbers entered manually. column C gives out the sum automatically.
2. the colour of the cells in column C change depending on the entered numbers in A and B:
- when the sum of cell A and B is zero: red
- when the cell in B is at least 4, and total sum of A and B is at least 5: green
- when the sum of cells A and B is higher than zero and B is lower than 4: yellow

Thank you so much in advance, Iam new to excel-vba and I don't know how to programm it, and it will help me a lot to dig deeper into this programming language!

[![enter image description here][1]][1]

  [1]: https://i.stack.imgur.com/sLGYH.png