View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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