| View previous topic :: View next topic |
| Author |
Message |
knievel
General User
Joined: 17 Dec 2008
Posts: 14
Location: Netherlands
|
 Posted: Mon Jan 05, 2009 4:51 am Post subject: changing backgroundcolour of today's date in a calender |
 |
|
| In a column with 365 cells, each containing a date of the year and defined as date, I want to highlight (change background colour) of today's date. I already created a style called date. Within the conditional styling I chosed either cell value = NU() or formula = NU(), neither gives the wanted result. I also created a cell with today's date using the formula =NU() and then let the selected cell compare if the value or the contenance is the same. Doesn't work. Does anybody know the solution? |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Mon Jan 05, 2009 6:27 am Post subject: |
|
|
Does NU() mean "Now" or "Today"? (In English Calc versions there are the functions NOW() and TODAY(), and I'm guessing you have used the equivalent of NOW())
NOW() returns date and time of day (according to the system clock).
TODAY() returns current date only, which is probably what you need. Try to find the corresponding function in your language. |
|
| Back to top |
|
|
knievel
General User
Joined: 17 Dec 2008
Posts: 14
Location: Netherlands
|
| Posted: Mon Jan 05, 2009 7:00 am Post subject: |
|
|
[/quote]Does NU() mean "Now" or "Today"? | Quote: |
Exactly, I realised to late that I used the Dutch word NU is NOW. The equivalent for Today can be VANDAAG or DAG. I´ll try this and let you know what the result is. Thanks for answering.
|
|
|
| Back to top |
|
|
knievel
General User
Joined: 17 Dec 2008
Posts: 14
Location: Netherlands
|
| Posted: Mon Jan 05, 2009 7:10 am Post subject: |
|
|
I tried VANDAAG equivalent to TODAY in English and now it is functioning perfectly. Thank you for your help.
Problem solved! |
|
| Back to top |
|
|
|
