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 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.
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.
Hi Milo,
I think what you want is a vlookup to select the status - which you already have , and that works fine - and a second vlookup to select the colour. I'm afraid it is not possible to have two vlookups in the same cell.
What I am struggling to understand is what determines the colour to be applied? It is not clear to me from the data you provided.
I still think the way to do this is conditional formatting based on certain conditions. I know you did not like the proposal I made before but you can adjust this to apply the formatting by checking (for example) the dates. So if a WP was due to be delivered by Jul-21 but was actually delivered by Aug-21 you could set the conditional format to RED. If on the other hand, it is delivered by Jul-21 then the format would be GREEN. And so on. Does that make sense?
Or are you looking for the user to manually set the colour using some criteria which are not held withing the spreadsheet? If that is the case you would need to resort back to the tool bar....
Unless you write a VBA macro to control this - but in my view that may be a sledgehammer to crack a nut approach!
Hope this helps.
Peter
I think what you want is a vlookup to select the status - which you already have , and that works fine - and a second vlookup to select the colour. I'm afraid it is not possible to have two vlookups in the same cell.
What I am struggling to understand is what determines the colour to be applied? It is not clear to me from the data you provided.
I still think the way to do this is conditional formatting based on certain conditions. I know you did not like the proposal I made before but you can adjust this to apply the formatting by checking (for example) the dates. So if a WP was due to be delivered by Jul-21 but was actually delivered by Aug-21 you could set the conditional format to RED. If on the other hand, it is delivered by Jul-21 then the format would be GREEN. And so on. Does that make sense?
Or are you looking for the user to manually set the colour using some criteria which are not held withing the spreadsheet? If that is the case you would need to resort back to the tool bar....
Unless you write a VBA macro to control this - but in my view that may be a sledgehammer to crack a nut approach!
Hope this helps.
Peter