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
|