Forum Discussion
Add colour drop down list to VLOOKUP cell
Hi Team, I would like to add a dropdown list of colours (green, amber, red) however no text to cell F4-F7 which uses a VLOOUKP. For example, the 'Status Delivery' stays the same, however I ...
Hi Milo,
Can you provide more information as to when you will apply red, amber, green? It is not clear from the dates which colour you want to apply?
let me know and I will see what can be done.
thanks
Peter
Can you provide more information as to when you will apply red, amber, green? It is not clear from the dates which colour you want to apply?
let me know and I will see what can be done.
thanks
Peter
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.
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.