Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Dates
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 ale 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 he current month in Red. I have tried the following and had mixed results. In each cell I have tried the following: 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
=1-1-2008 (1 minus 1 minus 2008) gives a result of -2008
=1-31-2008 gives a result of -2038 TODAY() cannot be both =-2008 and <=-2038 (and the current value of TODAY() is 39584). Perhaps instead of 1-1-2008 you intended to say DATE(2008,1,1) ? -- David Biddulph "BillXMachina" wrote in message ... 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 ale 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 he current month in Red. I have tried the following and had mixed results. In each cell I have tried the following: 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
|
|||
|
|||
Quote:
Try this formula with Conditional Formatting for cells A1:A12. =MONTH(DATE(1900,COLUMN(),1))=MONTH(TODAY()) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Dates
Did you mean ROW(), rather than COLUMN() ?
-- David Biddulph "GoBow777" wrote in message ... BillXMachina;667245 Wrote: 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 ale 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 he current month in Red. I have tried the following and had mixed results. In each cell I have tried the following: 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 Hello Bill: Try this formula with Conditional Formatting for cells A1:A12. =MONTH(DATE(1900,COLUMN(),1))=MONTH(TODAY()) -- GoBow777 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Conditional Formatting for Dates | Excel Discussion (Misc queries) | |||
conditional formatting using dates | Excel Discussion (Misc queries) | |||
Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
Conditional Formatting with Dates | Excel Worksheet Functions | |||
Conditional Formatting Dates | Excel Worksheet Functions |