Hi everyone.
I’m new to Libre Office & i’m struggling to format dates in a Training Matrix spreadsheet that I’ve created. I’m not sure what formulas to use e.g =TODAY()…(if any). I would like to have 3 separate colours that show for example - “courses in date”(green); “courses due for renewal” (within a future date e.g. 2 months) amber; “courses expired or out of date” red.
Any advice is very welcome. I had a similar sheet created in MS Excel years ago but this is not available to me any more.
Many thanks in advance.
Martin
