Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks to a date cell
Hi, Is it possible to have a hyperling between two sheets that jumps to the cell that is displaying today's date? I have a column on one sheet that has every day listed and at the top of the sheet I have the formula =TODAY() working. I then use conditional formatting to highlight the current day in the list by turning the text red. Can I link from another sheet to the cell displaying the date today? I guess it would have to be in a range as it would get confused by the fact that the date is being displayed in 2 cells, the one at the top of the sheet and the other in the list? Can ranges be applied in hyperlinks? Any pointers would be great. Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=497510 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks to a date cell
I put the dates in 'Sheet 2' in cells A2:A999 (with today's date also in A1).
Then I used this hyperlink formula: =HYPERLINK("#"&ADDRESS(MATCH(TODAY(), 'Sheet 2'!$A$2:$A$999,0)+1,1,1,1,"sheet 2")) (one cell) mevetts wrote: Hi, Is it possible to have a hyperling between two sheets that jumps to the cell that is displaying today's date? I have a column on one sheet that has every day listed and at the top of the sheet I have the formula =TODAY() working. I then use conditional formatting to highlight the current day in the list by turning the text red. Can I link from another sheet to the cell displaying the date today? I guess it would have to be in a range as it would get confused by the fact that the date is being displayed in 2 cells, the one at the top of the sheet and the other in the list? Can ranges be applied in hyperlinks? Any pointers would be great. Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=497510 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update cell based on date range | Excel Discussion (Misc queries) | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
? on "date last saved" in cell | Excel Worksheet Functions | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |