Highlight a row with the current date.

  • Thread starter Thread starter sword_fishx
  • Start date Start date
S

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 said:
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
Click to expand...
 
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
 
OK...
Then entered say =$A1=today()
But this does not work
Click to expand...

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?
 
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.
 
If your dates are always the first of the month, then you can use:
=$A1=date(year(today()),month(today()),1)

Regards,
Fred
 
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
 
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.
 
It would be:
=$a1=today()

Regards,
Fred

sword_fishx said:
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.
Click to expand...
 
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!
 
Back
Top