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