Date 'over value' conditional formatting
Hi, I have a column with dates (UK formatting DD/MM/YY), and would like to set up the cells to change style (eg different colour) once a set number of days has passed from today's date (I am trying for 2 weeks, or 14 days).
I've tried different ways within Conditional Formatting but nothing seems to work. I tried the solutions suggested here without success: https://ask.libreoffice.org/en/questi... (No change is made after entering the formulas)
There does not seem to be any other solutions on Google either. Does anyone have any suggestions to get this working please?
So I finally managed to get it to work. I have no idea what was wrong with the original file but once I copy/pasted the whole spreadsheet into a new file the formulas worked as expected. (The date formatting was correct from the start, I did not change anything apart from copy/paste into a new file.)
Both the solutions by @Lupp and @riosv work as described.
Thank you for the help.