Forum Discussion
Add colour drop down list to VLOOKUP cell
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.
Sorry - I am missing something here.
F4 and F5 look the same to me? How would I know that your team has nearly completed this status by the delivery date? The status delivery is the same in both cells?
Sorry , can you clarify further?
thanks
Peter
Hi peteryac60
Apologies, I am not explaining this well.
All I need is a drop down list on column F to show the colours red, amber, and green which my team will select on their own.
Dependent on the colour my team choose from the drop-down list, it will colour the cell in column F but keeping the VLOOKUP of the date at all times.
I have updated the attachment to show what I need but obviously the colours will show in a drop-down list.
Thanks,
Hi Milo
I am not aware of any way to apply colours using VLOOKUP.
A better option might be using conditional formatting. I have attached an example - the colour will change depending on the colour choosing in the new column F. I am not sure if this will meet your needs?
Of course , you can move the colour column out of the main table if that is preferable?
Hopefully this will give you some food for thought?
regards,
Peter
- Hi Peter,
Unfortunately this won't work, but thank you.
I am trying to allow a dropdown list of 3 colours for the user to choose from.
Thanks for your help anyways.