View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sanch
 
Posts: n/a
Default Excel Formula Help

I am trying to create a formula with flags to highlight when something has
become 30, 45, 60 days old. I am using the following code to create the age
of a project (=NETWORKDAYS(A4,TODAY())), and I would like the cell to
highlight different colors as it ages. Can I do this in Excel? If so, does
anyone know how to do this?

Thanks,

S cott