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

Excel Formula Help
 

Use conditional Formatting (- Format / Conditional Formatting). Press
on Add to create your ranges and change the colours you want by
pressing the format button!

I hope I was clear!

Excel Formula Help
 

Your formula is correct- the different colors are possible with
conditional formatting. Land the cell pointer on your formula cell and
on the menu click Format Conditional Formatting. You can then set
the parameters of your conditional format: if the cell value is between
one number and another number, shade the cell with a certain color.
You can click the Add button on that window to shade the cell with a
different color when the cell value is in another range. Your post
talked about a project aging at 30, 45, and 60 days- you'll need to
define the parameters of the conditional format according to the
definition of "30 days old" your company uses.