[Solved] Highlight today cell

Discuss the spreadsheet application
Post Reply
arfa2
Posts: 2
Joined: Sat Jun 22, 2019 10:08 pm

[Solved] Highlight today cell

Post by arfa2 »

I have a sheet set up for accommodation data, 1 sheet per month;
The sheet is split vertically in two - to fit across the screen. 1-15th top-half; 16-30th lower half.

I have cut this image down for easier load-view
sheet1.gif
A = location
B = start date for the month
until P = 1 to 15th of the month

A24 = location
B23 = 16th of the month - through until month end [P=30th, Q=31st]

Is it possible to have a cell that highlights 'today'?
I tried...
> set each cell across with DATEVALUE(datetext)
> test - IF(B; DATEVALUE("2019-06-23"); "TODAY")
didn't work.
I feel as if I might be able to work it if given a start direction. At the moment I suspect I am stabbing in the dark.
I hope the above stabs at least makes some sense

Any suggestions would be much appreciated.
Last edited by arfa2 on Sun Jun 23, 2019 2:18 am, edited 3 times in total.
OpenOffice 3.1 on Windows Vista
FJCC
Moderator
Posts: 9278
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: highlight today cell

Post by FJCC »

Take a look at the attached file. I used the menu Format -> Conditional Formatting to apply a cell style called Highlight, which I defined, when the value of the cell is equal to the value of the TODAY() function.
Attachments
Highlight_Today.ods
(9.84 KiB) Downloaded 191 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
arfa2
Posts: 2
Joined: Sat Jun 22, 2019 10:08 pm

Re: highlight today cell

Post by arfa2 »

Excellent.!
To save time formatting each cell - =B1+1 =C1+1 etc. I set the date for the first cell, press enter and then drag the cell bottom-right handle across the required cells. It auto updates.

Many thanks for the solution. Very elegant.
OpenOffice 3.1 on Windows Vista
Post Reply