I have a sheet from the Google Leaf Church. Column A shows the date of each service.
To make it more obvious at a glance, I would like the cells in column A to apply the format so that the dates in the past have a different color. The ideal would be to highlight the next upcoming date (or at least the dates in the current month or something like that).
I'm a little familiar with the conditional format, but I do not use it on dates. Is this possible and, if so, how can I do it?
In a perfect world, the whole row would be colored during the last weeks, but only the cell is enough if this is getting difficult.