Conditional formatting with dates
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?
|