Hello I have a libre cal with some data, how can I sort rows by date and color it by date? If date is younger color is lighter and if is older is darker.
Hi
You can use Format▸Conditional Formatting▸Color Scale as described in this FAQ#142
[EDIT]
I suggested Color Scale conditional formatting for your first question evoked the past of a lighter color to a darker. If you want to color in red the dates of more than three days you can use standard conditional formatting, e.g. :
- Condition:
Formula is - Formula:
TODAY()-A1>3
Regards
Thanks a lot, last question, how about condition for example if date is older than tree days than color to red?
@czassas
or
- cell
lowerTODAY()-3