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
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.
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.Originally Posted by mahmoud-lee
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.
Posting Permissions
Reply With Quote
Bookmarks