Apr 20 2021 03:55 AM
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 would like to add a colour to this cell.
Please can someone help?
Thank you
Apr 20 2021 04:10 AM
Apr 20 2021 04:25 AM
Apr 20 2021 04:32 AM
Apr 20 2021 04:44 AM
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,
Apr 20 2021 05:27 AM
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
Apr 20 2021 05:31 AM
Apr 20 2021 09:28 AM
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
Apr 21 2021 01:30 AM
Apr 22 2021 02:30 AM