CF

F

FC

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.
 
B

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)
 
F

FC

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
 
R

Rick Rothstein \(MVP - VB\)

Try...

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

or

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

Rick
 
R

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
 
B

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)
 
F

FC

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