I have a spreadsheet with dates in cells that are future holiday dates, and i
would like the cells to change colour when the date has passed.
In A1 I have the formula for todays date... today() but would like some
assistance on how I would format C4 which is the first of my dates to enable
the cell to change colour when the date in C4 has passed.

Thanks in advance

Bobby