| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight current date | Excel Discussion (Misc queries) | |||
| highlight current row/column | Excel Discussion (Misc queries) | |||
| calendar highlight current date | Excel Discussion (Misc queries) | |||
| how do I highlight the current row and column | Excel Discussion (Misc queries) | |||
| how to highlight current row & column automatically by a color | Excel Discussion (Misc queries) | |||
Hybrid Mode
