👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. Thank you! 👍👍 This video explains how to create a data validation drop down list in Excel that changes the fill (background) and/or font colour dependent on what is selected from the list: in other words a colour coded drop down. The change of colour is achieved through conditional formatting. ------------------------