View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kathrine Kathrine is offline
external usenet poster
 
Posts: 48
Default Conditional formatting with dates

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?