Highlight a row with the current date.
 

Hi, this problem should be easy, but I can't get it to work

Colum A10 as a date, with the month and year for the next two years listed.

I have the current datein A1, using today() forumla.

What I would like to do is highlight the row starting from A10 with as the
current date in it.

Tried conditonal formatting as follows
Selected the rows I want to be highlighted with the date.That would be say
A10 through to A60.
Selected Conditional formatting, then formula is
Then entered say =$A1=today()

But this does not work.
Where am I going wrong, can someone help me please.
Thanks

Highlight a row with the current date.
 

"sword_fishx" wrote:

Hi, this problem should be easy, but I can't get it to work

Colum A10 as a date, with the month and year for the next two years listed.

I have the current date in A1, using today() forumla.

What I would like to do is highlight the row starting from A10 with as the
current date in it.

Tried conditonal formatting as follows
Selected the rows I want to be highlighted with the date.That would be say
A10 through to A60.
Selected Conditional formatting, then formula is
Then entered say =$A1=today()

But this does not work.
Where am I going wrong, can someone help me please.
Thanks

Highlight a row with the current date.
 

Not real sure I follow you on this.

Maybe:

=A10=A$1

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Hi, this problem should be easy, but I can't get it to work

Colum A10 as a date, with the month and year for the next two years
listed.

I have the current datein A1, using today() forumla.

What I would like to do is highlight the row starting from A10 with as the
current date in it.

Tried conditonal formatting as follows
Selected the rows I want to be highlighted with the date.That would be say
A10 through to A60.
Selected Conditional formatting, then formula is
Then entered say =$A1=today()

But this does not work.
Where am I going wrong, can someone help me please.
Thanks

Highlight a row with the current date.
 

Hi T.Valko.
thanks for your reply.
Let me try and explain again
Colum A Colum B
Row1 1/1/09 EDATE(A1,6) formula
Row2 20/7/09 EDATE(A1,6) formula


now what I would like to do is when the date in colum A equals the current
date, lets say todays date. Then I want to do automatically is to highlight
the complete row with the current date in. So in this case Row2 should be
highlighted.
Hope this explains thing better.
Thank you


"T. Valko" wrote:

Not real sure I follow you on this.

Maybe:

=A10=A$1

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Hi, this problem should be easy, but I can't get it to work

Colum A10 as a date, with the month and year for the next two years
listed.

I have the current datein A1, using today() forumla.

What I would like to do is highlight the row starting from A10 with as the
current date in it.

Tried conditonal formatting as follows
Selected the rows I want to be highlighted with the date.That would be say
A10 through to A60.
Selected Conditional formatting, then formula is
Then entered say =$A1=today()

But this does not work.
Where am I going wrong, can someone help me please.
Thanks

Highlight a row with the current date.
 

OK...

Then entered say =$A1=today()
But this does not work

That's the correct formula, so what didn't work? What is the *exact* range
of cells you want to format? What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Hi T.Valko.
thanks for your reply.
Let me try and explain again
Colum A Colum B
Row1 1/1/09 EDATE(A1,6) formula
Row2 20/7/09 EDATE(A1,6) formula


now what I would like to do is when the date in colum A equals the current
date, lets say todays date. Then I want to do automatically is to
highlight
the complete row with the current date in. So in this case Row2 should be
highlighted.
Hope this explains thing better.
Thank you


"T. Valko" wrote:

Not real sure I follow you on this.

Maybe:

=A10=A$1

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Hi, this problem should be easy, but I can't get it to work

Colum A10 as a date, with the month and year for the next two years
listed.

I have the current datein A1, using today() forumla.

What I would like to do is highlight the row starting from A10 with as
the
current date in it.

Tried conditonal formatting as follows
Selected the rows I want to be highlighted with the date.That would be
say
A10 through to A60.
Selected Conditional formatting, then formula is
Then entered say =$A1=today()

But this does not work.
Where am I going wrong, can someone help me please.
Thanks

Highlight a row with the current date.
 

Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today() is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only looks at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months, but
again because today() is looking for an exact date it will not highlight the
row.

Highlight a row with the current date.
 

If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred

"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today() is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months, but
again because today() is looking for an exact date it will not highlight
the
row.

Highlight a row with the current date.
 

You didn't answer any of my questions! I can better help you if you answer
any questions I might have.

If you have true Excel dates in column A it doesn't matter how they are
formatted to display. As long as they are true Excel dates and there is a
match then:

=cell_reference=TODAY()

Will work as the conditional format formula.

If A1 = 7/20/2009 but is formatted to display as 7/2009...

=A1=TODAY() = TRUE

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today() is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months, but
again because today() is looking for an exact date it will not highlight
the
row.

Highlight a row with the current date.
 

Fred Smith, thanks that worked. No more pulling my hair out.!
What would the formula be if the dates was not the first of the month? But
any date of the month.

T. Valko, thank you for your help. Fred's solution worked. I am sorry I do
have problems explaining myself sometimes. It is a known problem on my part.



"Fred Smith" wrote:

If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred

"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today() is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months, but
again because today() is looking for an exact date it will not highlight
the
row.

Highlight a row with the current date.
 

It would be:
=$a1=today()

Regards,
Fred

"sword_fishx" wrote in message
...
Fred Smith, thanks that worked. No more pulling my hair out.!
What would the formula be if the dates was not the first of the month? But
any date of the month.

T. Valko, thank you for your help. Fred's solution worked. I am sorry I do
have problems explaining myself sometimes. It is a known problem on my
part.



"Fred Smith" wrote:

If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred

"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today()
is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only
looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months,
but
again because today() is looking for an exact date it will not
highlight
the
row.

Highlight a row with the current date.
 

Fred, thanks for your help. Greatly appreciated. You too T Valko

"Fred Smith" wrote:

It would be:
=$a1=today()

Regards,
Fred

"sword_fishx" wrote in message
...
Fred Smith, thanks that worked. No more pulling my hair out.!
What would the formula be if the dates was not the first of the month? But
any date of the month.

T. Valko, thank you for your help. Fred's solution worked. I am sorry I do
have problems explaining myself sometimes. It is a known problem on my
part.



"Fred Smith" wrote:

If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred

"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It is
because in Colum A, the date is in the format 01/01/2009. The today()
is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only
looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different date/months,
but
again because today() is looking for an exact date it will not
highlight
the
row.

Highlight a row with the current date.
 

I am sorry I do have problems explaining myself sometimes.

Not a problem. Sometimes I'm pretty dense when it comes to interpreting what
others have explained!

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"sword_fishx" wrote in message
...
Fred, thanks for your help. Greatly appreciated. You too T Valko

"Fred Smith" wrote:

It would be:
=$a1=today()

Regards,
Fred

"sword_fishx" wrote in message
...
Fred Smith, thanks that worked. No more pulling my hair out.!
What would the formula be if the dates was not the first of the month?
But
any date of the month.

T. Valko, thank you for your help. Fred's solution worked. I am sorry I
do
have problems explaining myself sometimes. It is a known problem on my
part.



"Fred Smith" wrote:

If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred

"sword_fishx" wrote in message
...
Hi T Valko,
I figured out why =$A1=today() does not highlight the row I what. It
is
because in Colum A, the date is in the format 01/01/2009. The
today()
is
looking at an exact match eg the date,month and year.

Do you do what to write in the formula =$A1=today(), where it only
looks
at
the month and year, then highlights the row??

I have tried changing the cell format to using different
date/months,
but
again because today() is looking for an exact date it will not
highlight
the
row.