Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? 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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting wth more than 3 conditions | Excel Worksheet Functions | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |