I want a cell to change its colour to green when another cell has yes in itl.
If it does not have yes in it i want it to be red. Ive tried using the iF
function but i dont know how it works and i keeep getting errors

Help is appreciated :)

Thank you