Hi, Thanks Anund. Anindya, are you using XL2003 or 2007? When you want to conditional format a whole block of data like the table I sent you, XL is very helpful and you only need to enter the formula once. First you need to select the whole table. You will notice that when you select a group of cells, the cell you begin with is highlighted in a different way. So when you select the cells in our table, you will probably start in cell A2, dragging down and across to cell D29. This highlights the whole table, but with A2 highlighted differently, which becomes the key cell for our conditional format formula. Write the formula as if you just wanted A2 formatted, and XL will put the formula into all the other cells in the selection, changing it as necessary. Very cool! The format you want, is only applied if the formula is TRUE. So, looking at our formula: =Month($D2)=$G$2 This asks, Is the month of the date in cell D2, equal to the number you selected in the drop-down in G2? If yes (TRUE) then apply the formatting. You say you are a beginner in Excel, so if you're not sure why the dollar signs ($) are in the formula, just ask. They are important. Or ask anything else you need to know. Regards - Dave.
> Date: Mon, 29 Nov 2010 22:43:17 -0800 > Subject: Re: $$Excel-Macros$$ > From: anand...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > Just saw your query and the solution both. Doing this would be simple > though. > > > Then you have formed a separate drop down column in G2 putting the months as > > reference - *How did you do this particular step??* > > This step is done through data validation. In Excel 2007 you can find > this in Data tab on the ribbon. In 2003 version it can be found in > Data menu. Select List in the Allow: drop down box and in the source > you type in 1,2,3,4....12 click on OK and you will have a drop down > box > > > *It also seems that you have done conditional formatting in the main table. > > But how is that only the month which am sorting is showing red in > > colour??You need to explain me this step too. > > Correctly guessed it is conditional formatting in the main table. In > the Select a rule type select "use a formula for cells to format" in > the formula type =Month($D2)=$G$2 in the format section choose the > font and fill type for the cell and you are done. > > In case you need further explanation feel free to reach me at > anand...@gmail.com. Hope that helps, > > @Dave : Perfect solution. Neat and clean work, my appreciations for > the solution > > Regards > Anand Kumar > > On Nov 29, 8:58 pm, Anindya Roy <anind...@gmail.com> wrote: > > Thanks a million Dave. You have just served it on a platter for me. > > > > Simply awesome. > > > > But would request you to explain the steps if possible as I am a begginer in > > excel. What I could decipher is that > > > > You have formed a separate column and have put the formula. > > > > Then you have formed a separate drop down column in G2 putting the months as > > reference - *How did you do this particular step??* > > > > *It also seems that you have done conditional formatting in the main table. > > But how is that only the month which am sorting is showing red in > > colour??You need to explain me this step too. > > * > > *Regards* > > *Anindya > > > > * > > On Mon, Nov 29, 2010 at 2:44 PM, Dave Bonallack > > <davebonall...@hotmail.com>wrote: > > > > > > > > > > > > > > > > > Hi, > > > Not quite sure what you mean by "sort out names" but have a look at the > > > attached. You can select the month you want by using the drop-down in cell > > > G2 (1 to 12) > > > The main table contains Conditional Formatting, while Col E contains > > > formulas. > > > Regards - Dave. > > > > > ------------------------------ > > > Date: Sun, 28 Nov 2010 23:15:14 +0530 > > > Subject: $$Excel-Macros$$ > > > From: anind...@gmail.com > > > To: excel-macros@googlegroups.com > > > > > Suppose I have a file which contains names of the candidates along with > > > their date of birth. Now if i want to sort out names which have birthday > > > falling in the month of november. > > > > > How do I do that. > > > > > Please note that DOB is mm/dd/yyyy format. > > > > > S.No > > > Beneficiary Name > > > Ward No > > > DOB > > > 1 > > > Ambarish Ghosh > > > 11 > > > 12/8/1985 > > > 2 > > > Anirban Chakraborty > > > 50 > > > 7/13/1991 > > > 3 > > > Anasuya Das > > > 21 > > > 6/21/1981 > > > 4 > > > Ananya Dasgupta > > > 37 > > > 8/28/1984 > > > 5 > > > Asish Majhi > > > 41 > > > 2/11/1990 > > > 6 > > > Amit Kumar Sharma > > > 27 > > > 2/12/1984 > > > 7 > > > Abhijit Golui > > > 37 > > > 9/30/1989 > > > 8 > > > Bidisha Manik > > > 12 > > > 7/19/1985 > > > 9 > > > Baishakhi Mallick > > > 9 > > > 4/15/1986 > > > 10 > > > Biswajit Paul > > > 10 > > > 9/18/1984 > > > 11 > > > Barnali Roy > > > 19 > > > 11/11/1976 > > > 12 > > > Dipanjan Karar > > > 18 > > > 1/20/1988 > > > 13 > > > Jesmine Mondal > > > 39 > > > 12/18/1985 > > > 14 > > > Kabita Mukherjee > > > 38 > > > 8/24/1984 > > > 15 > > > Kabita Roy Bagchi > > > 41 > > > 8/12/1980 > > > 16 > > > Kalpana Dey > > > 48 > > > 5/6/1983 > > > 17 > > > Kartick Ghosh > > > 48 > > > 11/17/1988 > > > 18 > > > Kuntal Mukherjee > > > 50 > > > 5/5/1982 > > > 19 > > > Madhumita Das > > > 39 > > > 6/4/1985 > > > 20 > > > Madhumita Sardar > > > 39 > > > 5/3/1986 > > > 21 > > > Moumita Debnath > > > 34 > > > 12/23/1988 > > > 22 > > > Poly Mukherjee > > > 45 > > > 9/16/1988 > > > 23 > > > Papia Nath > > > 49 > > > 10/21/1979 > > > 24 > > > Rituparna Pal > > > 22 > > > 12/6/1983 > > > 25 > > > Rini Banerjee > > > 33 > > > 4/21/1988 > > > 26 > > > Shrabani Dey > > > 40 > > > 8/5/1975 > > > 27 > > > Subhajit Sheet > > > 49 > > > 3/10/1991 > > > 28 > > > Soma Ghosh > > > 24 > > > 12/19/1979 > > > > > Thanks & Regards > > > Anindya Roy > > > > > -- > > > > > --------------------------------------------------------------------------- > > > ------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > > > > -- > > > > > --------------------------------------------------------------------------- > > > ------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
