LibreOffice Conditional Formatting Help
September 30, 2021 5:57 PM Subscribe
I have a LibreOffice spreadsheet (actually saved as .xls) (sample file here). I'm struggling to figure out conditional formatting.
There are multiple documents we need for each child that have to be reviewed every year. There is a column for the date the form was complete, 90 days before the due date and the due date. The later two dates, I've computed using cell+90 and cell+365. What I want to happen is for the second 2 cells (for example ETA (90) and ETA (due)) to turn red and stay red until the form is updated and I update the first cell (ETA) with the date the form is reviewed.
Right now, I'm trying to do this in LibreOffice (I do not have access to Excel) and then transfer everything to Google Docs so it lives in the cloud as opposed to thumb drive in my boss' desk.
I have tried reading the documentation and Googling. My brain isn't comprehending anything more complex than Chicka Chicka Boom Boom at the moment. Google gives me examples, but in my sheet, the second two dates are dynamically calculated and I haven't been able to find an example like that.
On preview, I see this Ask and this Ask but again, I'm just not comprehending.
There are multiple documents we need for each child that have to be reviewed every year. There is a column for the date the form was complete, 90 days before the due date and the due date. The later two dates, I've computed using cell+90 and cell+365. What I want to happen is for the second 2 cells (for example ETA (90) and ETA (due)) to turn red and stay red until the form is updated and I update the first cell (ETA) with the date the form is reviewed.
Right now, I'm trying to do this in LibreOffice (I do not have access to Excel) and then transfer everything to Google Docs so it lives in the cloud as opposed to thumb drive in my boss' desk.
I have tried reading the documentation and Googling. My brain isn't comprehending anything more complex than Chicka Chicka Boom Boom at the moment. Google gives me examples, but in my sheet, the second two dates are dynamically calculated and I haven't been able to find an example like that.
On preview, I see this Ask and this Ask but again, I'm just not comprehending.
To explain what I did in the example, for the 90 day cell, I just turned it red if the date is before today. For the second cell, I had to put a formula in the rules: where cell is less than or equal to =TODAY()+90.
posted by soelo at 6:46 PM on September 30, 2021
posted by soelo at 6:46 PM on September 30, 2021
I don't have an answer, but I'll suggest the LibreOffice community help page, ask.libreoffice.org/c/english/5. Search for the info you need, and if you don't find an answer, click "New topic" and ask — folks are very helpful, and you'll soon have an answer.
LibreOffice has its quirks, but it's far superior to paying money to Microsoft, which has enough money already.
posted by Doug Holland at 12:30 AM on October 2, 2021
LibreOffice has its quirks, but it's far superior to paying money to Microsoft, which has enough money already.
posted by Doug Holland at 12:30 AM on October 2, 2021
« Older Philadelphia Restaurant Filter: Outdoor dining? | How to become a person after "winning" at trauma? Newer »
This thread is closed to new comments.
Here is an example file I made with the solution only applied to the the first row. This is assuming you only want the two dates to turn red if the review is due in the next 90 days. It should not matter if your cell has a formula in it or an actual date. The formatting will apply the same in both cases.
posted by soelo at 6:43 PM on September 30, 2021 [1 favorite]