Forum Discussion
Add colour drop down list to VLOOKUP cell
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.Hi Milo,
I am still struggling to understand what you are trying to achieve. 🙂
In column F you have the vlookup which works fine and populates. I think what you want is an ability to colour those cells. Is that correct?
But do you want this colouring to be done manually by a user? Or do you want a value in the table to 'trigger' the change?
Does my question make sense?
Peter
- Hi Peter,
I want the vlookup to also have a dropdown to allow the user to colour to cell either green, amber or red.
The user will manually select the colour from the dropdown. The vlookup result will NOT change.