CF

[Guest]

I have columns with hundreds of dates.
I need a Conditional Formatting formula to text color all dates, let's say
in August.
I know how is done, just need the FORMULA, if somebody is so kind.
Appreciatte it. Thanks.

 

[Bob Phillips]

=TEXT(A1,"mmmm")="August")

or

=MONTH(A1)=8

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Shah Shailesh]

If you want to check only months, try this,
=MONTH(cell reference)=8

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.

 

[Guest]

Thanks for the formula. Bob Phillips you missed a parentesis in the first
formula, but I figured out. Thanks. Do you have one that will include the
month and the year too ?
Thank you also Shah Shailesh

 

[Rick Rothstein \(MVP - VB\)]

Try...

=AND(TEXT(A1,"mmmm")="August",YEAR(A1)=2007)

or

=AND(MONTH(A1)=8,YEAR(A1)=2007)

Rick

 

[RagDyeR]

Try this:

=TEXT(A1,"mm/yy")="08/07"

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Thanks for the formula. Bob Phillips you missed a parentesis in the first
formula, but I figured out. Thanks. Do you have one that will include the
month and the year too ?
Thank you also Shah Shailesh

 

[Bob Phillips]

Actually, I added one at the end.

=TEXT(A1,"yyyymm")="200708"

or

=TEXT(A1,"yyyymmm")="2007Aug"

or variations on these

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thank you Shah Shailesh, RagDyeR, Rick Rothstein and Bob Phillips for your
helpfull answers. Someone once said :
" Giving gives more satisfaction than receiving "