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