Conditional Formatting on more than "4" Conditions

[belly0fdesire]

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!

[dominicb]

Good evenin Bellyofdesire

Upper management eh? Where would we be without them?

There is an add-in available, CFPlus, that will handle 30 conditional formats. It's free and available from here;

http://www.xldynamic.com/source/xld.....Download.html

I've never actually used it so can't vouch for it, but for free it's got to be worth a try.

***BACK UP ALL YOUR DATA BEFORE TRYING ANYTHING NEW***

HTH

DominicB