Excel (upto 2003 version) only allows 3 conditions and sometimes you can put 4th conditon (default condition-the condition that exits by default).
In case you want to put more conditions then you'll have to use VBA as an alternate or upgrade to Excel 2007. On Thu, Apr 23, 2009 at 1:29 AM, Sam K <soura...@gmail.com> wrote: > Hi > > Why dont you try excel 2007 in that you can you use lol :) > > On Tue, Apr 21, 2009 at 6:26 PM, Steve <sspatri...@yahoo.com> wrote: > >> >> Hi, >> >> Can anyone tell me if there is a limit on the number of conditions you >> can place on a cell? I've got 5 and actually need 6, however, when I >> select apply, the last condition disappears. >> >> >> Please advise, >> >> Steve >> >> >> > > > -- > > ***************************************** > *~~ With Best Regards ~~ * > *~~~~~(Sourav.Kamra)~~~~~ * > **************************************** > > > > > -- Thanks and regards, Satti Charvak ____________________ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
