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.

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.

Put todays date somewhere on the sheet. For example, make the D1 formula
=TODAY().
Select the cell or cells you want to format. Use Format|Conditional
Formating and made Condition 1: Cell value greater than =$D$1 and then
click on the Format button and select the font and pattern (background)
colors.

"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.