I need a google sheets expert

We need google sheets to work better for our team. drop down lists, a link to a calender, cells changing colour when certain dropdowns are selected. just some of the examples