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
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.
[Solved] Highlight today cell
[Solved] Highlight today cell
Last edited by arfa2 on Sun Jun 23, 2019 2:18 am, edited 3 times in total.
OpenOffice 3.1 on Windows Vista
Re: highlight today cell
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: highlight today cell
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.
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