Add colour drop down list to VLOOKUP cell

Hi Peter,

Thank you for your response.
So I would like to give the user an option to colour the 'Status Delivery' date column.

For example, F4 should be the colour green as my team has nearly completed this status by the delivery date, however F5 should be red as the team has not completed the status by the delivery date.

I want the drop down list to be the 3 colours so they can easily colour the cell, rather than having to apply the colour from the toolbar each time. However please note, when colour coding the cells, the date should always be visible.

I hope this makes sense. Sorry if I am not being clear.