I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on how far in the past it is.
For example, if the date is within 3 months (of today’s date), the cell background colour should be red. If it’s between 3 and 6 months, the background should be yellow and if the date is over 6 moths ago, the background should be green.
I can’t see how to set conditions based on dates – can anyone help?