I want some of my cells to automatically change color by conditional formating.

1 condition for coloring/formating is that a separte cell on the spreadsheet
contains a date that is older than today....past time.

How can I write this condition?

Go to Format | Conditional Formatting

in the first drop dpwn select Formula Is

in the second box type =$C$2<TODAY()

(C2 is the cell that contains the date)

Click Format | Patterns Tab | Select the color.

hope this helps.


"Kathrine" wrote in message
...
I want some of my cells to automatically change color by conditional
formating.

1 condition for coloring/formating is that a separte cell on the
spreadsheet
contains a date that is older than today....past time.

How can I write this condition?

I used this formula to keep track of when documents are past-due. If this is
true, it's set to format the background of the cell in red.

=E3<TODAY()

Hope this helps!

Syrena

"Kathrine" wrote:

I want some of my cells to automatically change color by conditional formating.

1 condition for coloring/formating is that a separte cell on the spreadsheet
contains a date that is older than today....past time.

How can I write this condition?