OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

changing backgroundcolour of today's date in a calender

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
knievel
General User
General User


Joined: 17 Dec 2008
Posts: 14
Location: Netherlands

PostPosted: Mon Jan 05, 2009 4:51 am    Post subject: changing backgroundcolour of today's date in a calender Reply with quote

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
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Mon Jan 05, 2009 6:27 am    Post subject: Reply with quote

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
View user's profile Send private message
knievel
General User
General User


Joined: 17 Dec 2008
Posts: 14
Location: Netherlands

PostPosted: Mon Jan 05, 2009 7:00 am    Post subject: Reply with quote

[/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
View user's profile Send private message
knievel
General User
General User


Joined: 17 Dec 2008
Posts: 14
Location: Netherlands

PostPosted: Mon Jan 05, 2009 7:10 am    Post subject: Reply with quote

I tried VANDAAG equivalent to TODAY in English and now it is functioning perfectly. Thank you for your help.
Problem solved!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group