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... |
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... |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com