$$Excel-Macros$$ Re: Conditional Formats on Cells
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 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 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Conditional Formats on Cells
Hi Why dont you try excel 2007 in that you can you use lol :) On Tue, Apr 21, 2009 at 6:26 PM, Steve 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)~ * --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Conditional Formats on Cells
Sorry, I had the 5 formats set to give me a particular color if a certain cell was blank. After the blank rows, everything turned that color because the whole rows were blank, which isn't what I was after. So, my first attempt was to have a conditon to say if the first cell in a row was blank, to not have any format color. Since I had no format specified, it wasn't recognizing my condition. Therefore, I fixed it with the following: =AND($A2<>"",$L2="") I knew that if the first cell in a row was blank, then the whole row was blank. Therefore, no formatting on that row. Otherwise, if only L2 was blank, then change the color. Regards, Steve On Apr 21, 10:38 am, rspowell wrote: > Steve -- > > Excel 2003 is limited to 3 conditions > > -- since you are talking about 5 or 6 conditions, you must be working > in Excel 2007, without these same limitations > > Probably, your 6th rule is present - but, the Conditional Formatting > Rules Manager dialog is only large enough to display 5 rules > > ... look for the scrollbar on the Right side of the dialog -- maybe > this will enable you to see your other rules > > - Rodney POWELL > [ Microsoft MVP - Excel, 1997-2009 ] > > www.BeyondTechnology.com > > 2 8 1 - 3 7 9 - 2 0 0 0 > > On Apr 21, 7:56 am, Steve 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- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Conditional Formats on Cells
Steve -- Excel 2003 is limited to 3 conditions -- since you are talking about 5 or 6 conditions, you must be working in Excel 2007, without these same limitations Probably, your 6th rule is present - but, the Conditional Formatting Rules Manager dialog is only large enough to display 5 rules ... look for the scrollbar on the Right side of the dialog -- maybe this will enable you to see your other rules - Rodney POWELL [ Microsoft MVP - Excel, 1997-2009 ] www.BeyondTechnology.com 2 8 1 - 3 7 9 - 2 0 0 0 On Apr 21, 7:56 am, Steve 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 --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---