This worked for me.
Format | Conditional Formatting
Cell Value is
Greater than
=Today()

tj

"confusedjoel" wrote:

I am trying to change the colour of the cell according to the value,
specifically a date value. If a date in the cell is later than the present
date I would like the cell to turn red. Can anyone help.