increase conditional formatting in Excel

[Guest]

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...

 

[JulieD]

Hi

you basically have three options:
1) Bob Phillips has an add-in available for download from his site

www.xldynamic.com/source/xld.CFPlus.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