How can I conditionally format cells to denote past/future/current dates?

by Mr. Boy   Last Updated April 15, 2019 17:03 PM

I have a church rota Google Sheet. Column A shows the date of each service.

To make it more obvious at a glance, I would like cells in column A to apply formatting so that dates in the past are colored differently. Ideally, the next upcoming date would be highlighted (or at least dates in the current month or something like this).

I am somewhat familiar with conditional formatting but not using it on dates - is this feasible and if so how can I do it? In a perfect world, the entire row would be colored for past weeks but just the cell is sufficient if this is getting tricky.

Answers 1

  • before today: =COUNTIF($A1,"<"&TODAY())
  • today: =COUNTIF($A1,"="&TODAY())
  • after today: =COUNTIF($A1,">"&TODAY())


April 15, 2019 15:20 PM

Related Questions

Updated March 06, 2019 12:03 PM

Updated December 29, 2017 14:03 PM

Updated March 10, 2018 02:03 AM

Updated August 21, 2018 12:03 PM

Updated September 02, 2018 01:03 AM