Date conditional formatting in google sheets
07:16 12 Aug 2026

I'm trying to sort conditional formatting so that dates that occur BEFORE the date in cell D2/3/4 are coloured green, and dates that occur AFTER the date in cell D2/3/4 are coloured red.

I've checked that the columns are formatted as UK dates, but it still keeps colouring the after date as green as well :( any suggestions? I've spent ages trying to figure it out. attached is a screenshot of the data

google-sheets conditional-formatting