Excel - Conditional formatting

Hi all,

I am new to this and i am creating or trying to create a bespoke Excel programme (Gant) that i need for work.

i wanted to know if some could assist me with making a simple user tool as i need to share with colleagues i just cannot get the document to

1. Make it so anyone can simply change the task cell colour from the standard Excel pallet options
2. Make it so when the task cell colour is selected, the Gant cell changes to the same automatically
3. Be able to edit the text in any tsk cell and automatically save to drop down choices with all its text and colour inputted 
4. Within the assigned to column cells, create individual drop down options when in the cell itself as apposed to t the top line 

probably easy for some of you that are well versed in Excel formatting and Data validation

but certainly not me

any help would be appreciated 

thanks in advance

Mike 

mailto:email address removed for privacy reasons