Conditional Format - Date R.C. 13.07.2006 17:22:02 I have a question that I home y'all may be able to help me with: I am trying to use Conditional Formating for some dates. What I want to do is have only certain dates to be in bold and older ones not to be. ie., if I am entering dates for June on a spreadsheet for the month of June, I just want the dates for June of 2006 to be in bold and not the others. I have done value ranges (equal to 6/1/06 to 6/30/06) but I don't want to always be doing this with each month. Thanks!

Re: Conditional Format - Date "Bob Phillips" <bob.NGs[ at ]somewhere.com> 13.07.2006 17:50:25 Try a formula of say =MONTH(A1)=MONTH(TODAY()) assuming the date is in A1. If you span years, then use =AND(YEAR(A1)=YEAR(TODAY()),MONTH(A1)=MONTH(TODAY())) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "R.C." <R.C.[ at ]discussions.microsoft.com> wrote in message news:1D085D1F-6C04-45C4-A95D-B32029848041[ at ]microsoft.com... [Quoted Text] > I have a question that I home y'all may be able to help me with: I am trying > to use Conditional Formating for some dates. What I want to do is have only > certain dates to be in bold and older ones not to be. ie., if I am entering > dates for June on a spreadsheet for the month of June, I just want the dates > for June of 2006 to be in bold and not the others. I have done value ranges > (equal to 6/1/06 to 6/30/06) but I don't want to always be doing this with > each month. Thanks!