Conditional Formatting on more than "4" Conditions
 

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? :confused: Any ideas would
be greatly appreciated... Thanks in advance!


--
belly0fdesire
------------------------------------------------------------------------
belly0fdesire's Profile: http://www.excelforum.com/member.php...o&userid=25974
View this thread: http://www.excelforum.com/showthread...hreadid=401210

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=401210