+ Reply to Thread
Results 1 to 12 of 12

Calendar to highlight current day

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Calendar to highlight current day

    Got this Birthday Calendar on this site and just trying to make little changes. Is there a way to have the current day highlighed,and default the year to current in D1. This
    is a handy thing to have for older people that forget friends Birthdays. LOL
    Attached Files Attached Files
    Last edited by zplugger; 02-28-2013 at 10:49 AM.

  2. #2
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Got the current day to work(Conditional Formatting Highlight Cell Rules), just need to get the year right on workbook open.

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Maybe if this is not possible a MessageBox to show wrong year?. The workbook should
    open to current year.

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Any other suggestion to make this work? Just not sure how to do
    a messagebox if calendar is on a different year from current year.
    Z

  5. #5
    Registered User
    Join Date
    12-26-2012
    Location
    Meerut
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Calendar to highlight current day

    Dear Zplugger

    do u want the cell to be highlighted for today's date (D-MMM-YY) or you want only date (D) ?

    hope u understand!

  6. #6
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Hello
    I'm trying to get cell D1 to show current year on workbook open (2013). Right now the cell uses Data Valation to set the year, I still
    want this option, just trying to default the cell with current year on open. When you change the years the calendar changes to,I guess if
    I could get D1 to show current year that would work, and forget about changing the year with valation.

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calendar to highlight current day

    Do you mean?

    =YEAR(TODAY())
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  8. #8
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Sorry if I did not explain right, you have to look at sample to see what I mean. In D1 it shows the year that was set in Data Valation, I want to be able
    to change years if I can but not a big deal.I want D1 to be on current year,but if I set it the calendar does not work?. Think something in cell D3 needs changed.

  9. #9
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calendar to highlight current day

    Perhaps something like this?
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Yes that is Perfect Fotis. I will play around a little and see if when I change the year the age of a person changes to if they have a birthday in that month.

  11. #11
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calendar to highlight current day

    I checked only changing the year. Check it and if you have any other problem, just let me know..

  12. #12
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Calendar to highlight current day

    Here is what I ended up with, maybe someone can use it to. Special thanks to Fotis for getting me on right track.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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