Employees are in one column and their department is in another. This is for a multi-user attendance tracking system I'm trying to put together for my company. I'm going to creat a validation list with the departments in it. I want the user to be able to select the department in the dropdown under the department column and have it change the color of the font of the employees name in the other column. This will help upper management better distinguish departments in the master list. My problem is that I have 8 departments and Excel will only allow me to make 3 different conditions... 4 if you count the default color of the font. Does anyone know a way around this? Any ideas would be greatly appreciated... Thanks in advance!