Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
=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) "FC" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
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. "FC" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
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" wrote: =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) "FC" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
Try...
=AND(TEXT(A1,"mmmm")="August",YEAR(A1)=2007) or =AND(MONTH(A1)=8,YEAR(A1)=2007) Rick "FC" wrote in message ... 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" wrote: =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) "FC" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
Try this:
=TEXT(A1,"mm/yy")="08/07" -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "FC" wrote in message ... 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" wrote: =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) "FC" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
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) "FC" wrote in message ... 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" wrote: =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) "FC" wrote in message ... 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF
Thank you Shah Shailesh, RagDyeR, Rick Rothstein and Bob Phillips for your
helpfull answers. Someone once said : " Giving gives more satisfaction than receiving " "Shah Shailesh" wrote: 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. "FC" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|