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

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

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

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

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

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