Home |
Search |
Today's Posts |
#1
|
|||
|
|||
increase conditional formatting in Excel
I am interested in increasing the number of conditions I apply.
Currently, excel offers 3, I need 4. If severity of case is Business Critial and Age in Days is greater than 3, then color case id blue. If severity of case is High Urgency and Age in Days is greater than 6, then color case id red If severity of case is Low Urgency and Age in Days is greater than 14, then color case id yellow If severity of case is Routine and Age in Days is greater than 30 then color case id light tan... |
#2
|
|||
|
|||
Hi
you basically have three options: 1) Bob Phillips has an add-in available for download from his site http://www.xldynamic.com/source/xld.....Download.html 2) John McGimpsey has notes on his site on how to do up to 6 without VBA http://www.mcgimpsey.com/excel/conditional6.html 3) Use VBA - if you'ld like more details on how to implement this method please post back -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "JerrodMContee" wrote in message ... I am interested in increasing the number of conditions I apply. Currently, excel offers 3, I need 4. If severity of case is Business Critial and Age in Days is greater than 3, then color case id blue. If severity of case is High Urgency and Age in Days is greater than 6, then color case id red If severity of case is Low Urgency and Age in Days is greater than 14, then color case id yellow If severity of case is Routine and Age in Days is greater than 30 then color case id light tan... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions |