Forum Discussion

Brass Contributor

Apr 20, 2021

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 ...

Example.xlsx11 KB

excel

Formulas and Functions

office 365

training

milo1234

Brass Contributor

Apr 20, 2021

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,

peteryac60

Iron Contributor

Apr 20, 2021

milo1234

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