Highlight a row with the current date.

[sword_fishx]

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

 

[sword_fishx]

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

 

[T. Valko]

Not real sure I follow you on this.

Maybe:

=A10=A$1

 

[sword_fishx]

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]

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?

 

[sword_fishx]

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.

 

[Fred Smith]

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

Regards,
Fred

 

[T. Valko]

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

 

[sword_fishx]

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]

It would be:
=$a1=today()

Regards,
Fred

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.

 

[sword_fishx]

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

 

[T. Valko]

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!