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 <rod...@beyondtechnology.com> 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 <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- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
