How To Use Data Validation In Excel With Color
hello everyone in this video we learn how to use data validation with color in excel so i have employee list and i want to create drop-down for department and apply different color for each. i just select department column and use data validation for make drop-down from department list. then using conditional formatting i apply color like yellow for HR and green for IT and so on. when i select department from list, its show automatic color as per department. #excel #exceltips #exceltips #exceltutorial #exceltricks #excelformula #microsoftoffice #exceltipsandtricks