Results 1 to 3 of 3

Thread: A Blinking Christmas Tree...

  1. #1
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13

    A Blinking Christmas Tree...

    Just a reminder... it is December, and if you celebrate Christmas, then it is time to start thinking about getting a Christmas tree for the house. But what about for your computer? If you want to put your desk at home or in your workplace into the holiday spirit as well, then you might like my Excel blinking Christmas tree which can be found here...


    http://www.excelfox.com/forum/f22/a-...tmas-tree-708/


    Enjoy,

  2. #2
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Great work mr Rick
    But is it possible to do that by the formula ?
    Is it possible to also write (2014)
    The bottom of the tree the same way
    Last edited by mahmoud-lee; 12-04-2013 at 01:50 AM.

  3. #3
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by mahmoud-lee View Post
    But is it possible to do that by the formula ?
    No, the general rule is that Excel formulas using built-in functions cannot effect anything except the value they display in the cells they occupy. The code is needed to change the colors of the balls and run the timer which directs the frequency those colors change at.

    Quote Originally Posted by mahmoud-lee View Post
    Is it possible to also write (2014)
    The bottom of the tree the same way
    Why 2014... the current year is 2013? As for putting the date in the worksheet... it is just a worksheet, you can do that yourself manually. Here is how I would suggest you modify it. Type the range P43:R44 into the Name Box (located to the left of the Formula Bar)... that will select the cells... then use the Cell Formatting dialog box (press CTRL+1 to bring it up), select the Alignment tab and then put a check mark in the "Merge cells" check box... next, set the Horizontal and Vertical Text alignment drop downs each to Center, then click OK. Next, select those merged cells and put this formula in it...

    =YEAR(NOW())

    If you really want to display 2014 for some reason, just add one to the above formula.

Similar Threads

  1. A Blinking Christmas Tree
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 5
    Last Post: 12-28-2014, 02:48 PM
  2. Blinking cell
    By sanjeevi888 in forum Excel Help
    Replies: 3
    Last Post: 10-08-2012, 02:32 PM
  3. Merry Christmas and Happy New Year
    By Admin in forum Greetings and Inception
    Replies: 1
    Last Post: 01-02-2012, 12:54 PM

Posting Permissions

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