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 would like to add a colour to this cell. 

 

Please can someone help? 

Thank you

excel
Formulas and Functions
office 365
training

9 Replies

  • 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

Resources