status of the project

Hi,

I would like to show the status of the project as below:

- If any of milestones MS01 to MS04 is containing date then i would like show the word "YELLOW" in my sheet2

- if any of the milestones MS01 to MS04 is containing PROBLEM then i would like to show the word "RED" in my sheet2.

- if milestone MS05 containing date then i would like to show the word "BLUE" in my sheet2

- if milestones MS01 to MS05 is blank then i would like to show the word "WHITE" in my sheet

I attached the worksheet along.

Please kindly advice. Your comments will ber very much appreciated.