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.
You can use
Color Scale as described in this FAQ#142
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. :
Thanks a lot, last question, how about condition for example if date is older than tree days than color to red?
@czasas See update of my answer…