J Jay Jul 12, 2004 #1 Why does conditional formatting only allow (3) conditions and what can I do to add more conditions?
N Norman Harker Jul 12, 2004 #2 Hi Jay! Conditional formatting is limited to three conditions. Why? It's a specification. However you do have the default format that applies where no condition is satisfied. You also have the possibility of different formats for (usually) positive, negative and zero. But in most cases where you need more than three formats for your conditions, you will need to resort to VBA. For this, see: Dave McRitchie: http://www.mvps.org/dmcritchie/excel/event.htm#case However, if you are doing this for mainly presentation purposes, my own view is that you should try to avoid too many different colours.
Hi Jay! Conditional formatting is limited to three conditions. Why? It's a specification. However you do have the default format that applies where no condition is satisfied. You also have the possibility of different formats for (usually) positive, negative and zero. But in most cases where you need more than three formats for your conditions, you will need to resort to VBA. For this, see: Dave McRitchie: http://www.mvps.org/dmcritchie/excel/event.htm#case However, if you are doing this for mainly presentation purposes, my own view is that you should try to avoid too many different colours.
P Peo Sjoblom Jul 12, 2004 #3 You would need macro for that unless you can use something like http://www.mcgimpsey.com/excel/conditional6.html -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
You would need macro for that unless you can use something like http://www.mcgimpsey.com/excel/conditional6.html -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
