+ Reply to Thread
Results 1 to 5 of 5

Automatic movement of date indicator on spreadsheet

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Automatic movement of date indicator on spreadsheet

    I'm not sure if this is possible in Excel.

    My current contract has me managing a project for a software implementation. The business doesn't have Microsoft Project so I've drawn up a project task list for the next three months.

    The tasks and responsible party(s) I've listed in the far left two columns with each column thereafter headed by the day and date in sequence through to end of May. What I would like is to have some form of indicator which comes from the top row (which contains each day and date) through to the last row indicating the current date. This would update automatically based on the current date and therefore give some perspective on what stage the parties should have reached with their task.

    Updating the date automatically is easy but having a moving indicator across the spreadsheet is where I get stuck.


    Looking forward to hearing from anybody who could help me.

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Automatic movement of date indicator on spreadsheet

    You could use conditional formatting to color code the header cell (or wherever you want your indicator to be).

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Automatic movement of date indicator on spreadsheet

    So, you want the column that represents today's date to be highlighted?

    You can do this using conditional formatting.

    Let's assume your dates are in the range C1:H1 and your data area is in the range C2:H10.

    Select the *entire* range C1:H10 starting from cell C1.
    Cell C1 will be the active cell. The active cell is the
    one cell in the selected range that is not shaded. The
    formula will be relative to the active cell.

    Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format

    Enter this formula in the box below:

    =C$1=TODAY()

    Click the Format button
    Select the desired style(s)
    OK out
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    08-30-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Thumbs up Re: Automatic movement of date indicator on spreadsheet

    Quote Originally Posted by Tony Valko View Post
    So, you want the column that represents today's date to be highlighted?

    You can do this using conditional formatting.

    Let's assume your dates are in the range C1:H1 and your data area is in the range C2:H10.

    Select the *entire* range C1:H10 starting from cell C1.
    Cell C1 will be the active cell. The active cell is the
    one cell in the selected range that is not shaded. The
    formula will be relative to the active cell.

    Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format

    Enter this formula in the box below:

    =C$1=TODAY()

    Click the Format button
    Select the desired style(s)
    OK out
    Tony,

    that's outstanding - exactly what I was trying to do.


    Thanks very much.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Automatic movement of date indicator on spreadsheet

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1