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


.

Relevant Pages

  • Re: Email Booster from Excel
    ... You can use Display instead of Send and then attach the file you want. ... Dim cell As Range ... Set OutApp = CreateObject ... 1.Instead of yes/no in criteria I wanted have it compared with date if the date and time matches to todays date and time then "yes" else no. ...
    (microsoft.public.excel.programming)
  • Re: Stuck and getting frustrated. Can you assist
    ... then refer to that cell in column C. ... > Have a worksheet which monitors people attendance on a course. ... > to remain blank instead of defaulting to todays date. ... > commencement date then B1 automatically defaults to todays date. ...
    (microsoft.public.excel.misc)
  • Re: GOING TO A PARTICULAR CELL BASED ON LOOKUP CRITERIA
    ... Using the "Today" function I have todays date in Cell A5 ... ideally would like to open the spreadsheet to row 13 for todays date. ... I would click to click a macro button with "go to ...
    (microsoft.public.excel)
  • WB before save event problem
    ... I have a PO log workbook which has an "if" formula in Columnwhich ... enters todays date in the cell, if anything is filled in Columnsame ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: formula for high lighting rows
    ... if todays date is less than 5 days prior the date in the cell, ... if todays date is 0 days prior or greater the date in the cell, high light ...
    (microsoft.public.excel.programming)