Forum Discussion

milo1234's avatar
milo1234
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 ...
excel
Formulas and Functions
office 365
training
peteryac60's avatar
peteryac60
Iron Contributor
Apr 20, 2021
Hi Milo,

Can you provide more information as to when you will apply red, amber, green? It is not clear from the dates which colour you want to apply?

let me know and I will see what can be done.

thanks

Peter
  • milo1234's avatar
    milo1234
    Brass Contributor
    Apr 20, 2021
    Hi Peter,

    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.
    • peteryac60's avatar
      peteryac60
      Iron Contributor
      Apr 20, 2021
      Hi Milo,

      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
      • milo1234's avatar
        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,

Resources