Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 5th 05, 04:11 PM
JerrodMContee
 
Posts: n/a
Default 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   Report Post  
Old April 5th 05, 04:16 PM
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...







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying conditional formatting...HELP PLEASE!!!! trixiebme Excel Worksheet Functions 3 March 24th 05 01:53 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Formulae, conditional formatting & macro security Kevin Lucas Excel Discussion (Misc queries) 7 March 15th 05 01:10 PM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 06:03 PM
Conditional Formatting Graham Warren Excel Worksheet Functions 0 November 7th 04 04:58 PM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017