Thread: NETWORKDAYS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default NETWORKDAYS

Conditional Formatting

Formula Is: =A1=15
Format as red


"Suzanne" wrote:

I currently have an Excel 2000 worksheet which tracks a project using
NETWORKDAYS to calculate the number of days taken between the start and end
date of the project.

However, I now need to have a column which shows a running total of
NETWORKDAYS taken so far (so there will be no end date) and when it reaches
15 days the number changes to red.

Can anyone help before I loose face.

Thank you for your assistance.
Suzanne