I have a sheet of Google church rota. Column A shows the date of each service.
To make this more obvious at a glance, I would like the cells in column A to apply formatting so that past dates are colored differently. Ideally, the next upcoming date would be highlighted (or at least the dates of the current month or something like that).
I know a little about conditional formatting, but I do not use it on dates. Is it feasible and if so, how can I do it?
In a perfect world, the whole line would be colored during the past weeks, but the cell is enough if it becomes complicated.