Excel Formula Help

S

Sanch

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
 
M

Mark

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!
 
D

Dave O

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.
 
Top