View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Eade Dave Eade is offline
external usenet poster
 
Posts: 53
Default Help with Excle Formula

Hi, I'm trying to write a formula to do the following.

1. I have a cell which is returning "todays date"/
2. I have a column of activities which each have a date due and a "Yes/No"
completed value.

I want to write a forula which tests whether the Due Date is in the Past and
the Completed Flag is Set to "No"

Once I have this Value I want to conditionally format the Description based
on this Vales.

And befire anyone says, I know I should use MS Project, but the client I'm
working doesn't want to use it and lots of people who have never used MSP
will need access to and read/write to the excel.

Hope someone can help, virtual beers are on me!

Cheers
--
Dave Eade