formating a cell with a conditional if statement

[Rich]

I'd like to write an if statement that would compare a
date to todays's date and if the date is before today's
date color the cell red and if after today's date color
the cell green. Any suggestions on how to write the if
statement?

 

[Henrik Wendel]

Create a defined name (Ínsert/Name/Define)

Let it refere to a formula like this Today() name it ThisDay

Then create a conditional formating saying

Cell value / Less then / =Thisday

Wendel