Select all cells in the worksheet-Conditional Format-Formula

=(TODAY()-DATE (year $ 1)+ 1, month $ 1)- 1, day $1) >; =0

Set the conditional format color shading to red.

The effect is as follows, see the attachment for details.