| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Dates (Revised)
Sorry please ignore my previous posting.
I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting with Dates (Revised)
Hi Bill
Try =MONTH(TODAY())=MONTH($A1) -- Regards Roger Govier "BillXMachina" wrote in message ... Sorry please ignore my previous posting. I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting with Dates (Revised)
Assumming cells A1 throught A12 are TEXT, try a formula similar to:
=$A1=TEXT(TODAY(),"MMMM") Good Luck. "BillXMachina" wrote: Sorry please ignore my previous posting. I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting with Dates (Revised)
Hi Roger and ND Pard
I tried both of these solutions and neither one works. I don't understand what the problem might be. I put the formulas into the cells for each month and then changed the date on the computer and nothing changes. "Roger Govier" wrote: Hi Bill Try =MONTH(TODAY())=MONTH($A1) -- Regards Roger Govier "BillXMachina" wrote in message ... Sorry please ignore my previous posting. I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting with Dates (Revised)
Hi Bill
It looks as though you may have text values in a1:A12 Enter 01/01/2008 in A1 and use the fill handle to copy down to A12. It should then show 02/01/2008, 03/01/2008 etc. Select cells a1A12FormatcellsCustom mmmm You should now see January, February etc displayed, but the underlying values will be true Excel dates and the comparison should work -- Regards Roger Govier "BillXMachina" wrote in message ... Hi Roger and ND Pard I tried both of these solutions and neither one works. I don't understand what the problem might be. I put the formulas into the cells for each month and then changed the date on the computer and nothing changes. "Roger Govier" wrote: Hi Bill Try =MONTH(TODAY())=MONTH($A1) -- Regards Roger Govier "BillXMachina" wrote in message ... Sorry please ignore my previous posting. I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting with Dates (Revised)
Roger,
Thank you, that did it! I appreciate the help. Thanks, Bill "Roger Govier" wrote: Hi Bill It looks as though you may have text values in a1:A12 Enter 01/01/2008 in A1 and use the fill handle to copy down to A12. It should then show 02/01/2008, 03/01/2008 etc. Select cells a1A12FormatcellsCustom mmmm You should now see January, February etc displayed, but the underlying values will be true Excel dates and the comparison should work -- Regards Roger Govier "BillXMachina" wrote in message ... Hi Roger and ND Pard I tried both of these solutions and neither one works. I don't understand what the problem might be. I put the formulas into the cells for each month and then changed the date on the computer and nothing changes. "Roger Govier" wrote: Hi Bill Try =MONTH(TODAY())=MONTH($A1) -- Regards Roger Govier "BillXMachina" wrote in message ... Sorry please ignore my previous posting. I hope someone will be able to help me. I have tried a number of things but can't get this just right. I want to be able to make the text in a cell turn red if todays date is between two dates. Example: in Cells A1 through A12 are the months of the year (January, February, March, April, May, June, July, August, September, October, November, December). I want to highlight the current month in Red. I have tried the following and had mixed results. In each cell I enter the following formula with the appropriate dates for that month. The examples below are for cell A1 (January): Assume today is January 15th. The text in cell A1 should turn red while A2 through A12 stay black. 1. =OR(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Turns text red regardless of current date 2. =AND(TODAY() = 1-1-2008, TODAY() <= 1-31-2008) Results = Does not turn text red regardless of current date I'm not sure whats wrong here, please help. Thanks, Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
| Conditional Formatting - dates | Excel Discussion (Misc queries) | |||
| Revised dates in excel | New Users to Excel | |||
| Dates in Conditional Formatting help!!! | Excel Worksheet Functions | |||
| Conditional Formatting w/ Dates | Excel Discussion (Misc queries) | |||
Linear Mode
