Before i’ve known the following tip, i used to format my cells in a google sheet based on the current day with indirection functions and such stuff. To check if the column A of the current row contains a date later than today, i used the following expression:
After a recent discussion with a colleague it could be made WAY easier. To conditionally format, e.g. the range of D6:N36 based on the date of the column A in the current row simply use instead:
=$A6 > TODAY()
and your’e done!
Sometimes life is way more simple than you think 🙂