One way:

Select your cells. Assume A1 is active. Choose Format/Conditional
Formatting...

CF1: =A1<TODAY()
Format1: Patterns/<desired color


In article ,
George wrote:

In my spread sheet there are row of dates. How can I just conditional
formatting to have the background color of each cell change when the date is
older then today's date.