Create Drop Down List in Excel with Color (Data Validation)

Learn how to create Drop Down List in Excel with color. Add data validation and control the data entered with a drop-down list. This video uses examples to make the set up easy to follow. This is an alternative way of adding data validation. Creating a dropdown list makes data entry easier. 📌Complete Excel Foundation Course: https://shop.presentation-process.com/p/complete-excel-foundation-course What is covered in this Excel tutorial: ============== 00:00 Introduction 01:45 Add Dropdown List from a separate sheet 02:55 Add Conditional Format based on the data entered 05:25 Converting cells into a Table 06:05 Extend data validation to other cells #ramgopalexcel This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.