Ask Your Question

Get libreoffice to highlight today's date…? [closed]

asked 2017-05-30 09:22:10 +0200

appreciatethehelp gravatar image

Hey guys. Just wondering how to set LO to highlight today's date.

Attached an annotated screenshot detailing what I want.


C:\fakepath\Screen Shot 2017-05-30 at 7.16.00 PM.png

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-06-19 05:59:23.981935

2 Answers

Sort by » oldest newest most voted

answered 2017-05-30 11:03:05 +0200

komma4 gravatar image

My LO version ( has the Conditional Formatting option: Date value and comparison Today.

You don't have to set the NOW() formula (as @robleyd suggests) using that one.

edit flag offensive delete link more


Thanks for that - obviously LO is ahead of AOO in this area.

robleyd gravatar imagerobleyd ( 2017-05-30 11:11:37 +0200 )edit

answered 2017-05-30 10:30:27 +0200

robleyd gravatar image

Conditional formatting is probably the solution you want - set a cell somewhere out of the way to be =NOW()

Create and name (e.g. Current day) a style that has the appearance you want. Select the range of dates you want to manage and go to Format | Conditional Fomatting. Set Cell value is Equal To the absolute address of the cell containing =NOW() and set the cell style to Current day or however you have named the style you created.

I'm not sure if this will override the existing styles - you may need to experiment a bit.

edit flag offensive delete link more


There is Date is condition in conditional formatting that is better suited for the task. NOW() will probably not work - both because it contains time (which you may override by simply truncating its value, and because user dates may also have times, just hidden by formatting, so formulas should be used instead of values)

Mike Kaganski gravatar imageMike Kaganski ( 2017-05-30 10:59:48 +0200 )edit

Whoever have minused the answer: this is not a proper action. The answer is not useless; even if it isn't complete, it gives a direction, and may be used as a basis on systems where there's no Date is conditions (AOO users may also come here to find information). Only downvote answers that are outright wrong or off-topic, please.

Mike Kaganski gravatar imageMike Kaganski ( 2017-05-30 22:33:16 +0200 )edit

Question Tools

1 follower


Asked: 2017-05-30 09:22:10 +0200

Seen: 49 times

Last updated: May 30