I have a spreadsheet with a different row for each day. At the start of each row in column A I have: =IF(B559=$A$1,"TODAY","")) [A1 has simply =today()] and then in Column B the date (B559=6/7/2006, B560 is 7/7/2006 etc). Column A is conditionally formatted to show today's date in red. But I would also like a button that would automatically go to today's row, not to A1.
Grateful for any ideas.