+ Reply to Thread
Results 1 to 4 of 4

Highlight Sheet based on Current Date?

Hybrid View

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Highlight Sheet based on Current Date?

    I have 52 sheets (one for every week of the year) an dI would like to highlight the sheet tab for the date that is occurring this week. It should also un color when it moves on to the following week.

    Sheets named as "Dec 9, 2022" or "Apr 4, 2022" Etc. They're based on week ending dates (based on Fridays)

    Not sure if this is even possible but worth a shot. I would just like to have the current week highlighted so the user entering data can find the current sheet easily. Other option would just be a macro that jumps to current date, but they can already kind of do that with the built in Sheet jumplist.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: Highlight Sheet based on Current Date?


    Why not just comparing sheets names and the current date ? …

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,355

    Re: Highlight Sheet based on Current Date?

    Hi NewYears,

    See if this short sample gets you closer to what you want. The Worksheet VBA code does the trick. I wrote some other to name the tabs for my sample.
    Activate Today Tab WeekNum.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Highlight Sheet based on Current Date?

    Hey sorry for the slow reply, some how I missed your reply. This actually worked for what I was trying to do Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Returning a value in a sheet based on current date and time
    By Linda G in forum Excel General
    Replies: 4
    Last Post: 11-26-2022, 01:52 AM
  2. Replies: 4
    Last Post: 03-25-2022, 11:51 AM
  3. Change date on sheet based on current date
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2016, 10:10 AM
  4. Highlight Rows Based on Date Range Using Static Date and Current Date
    By SaraStravers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 07:38 PM
  5. Replies: 8
    Last Post: 07-26-2013, 06:29 PM
  6. Highlight Only Current Week Based on Date
    By Kumara_faith in forum Excel General
    Replies: 10
    Last Post: 11-17-2010, 04:52 PM
  7. Excel 2007 : Highlight the current date
    By Crawtim in forum Excel General
    Replies: 2
    Last Post: 08-23-2010, 10:02 AM

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