Sorting and coloring

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 FormatConditional FormattingColor Scale as described in this FAQ#142


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


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…



  • cell lower TODAY()-3