ExcelBanter - View Single Post

John Moore

Ok Dave, glad I could help

"Dave Eade" wrote:

Hi John,

I think I've worked it out now.

I use the "AND" function and supply 2 arguements, if they are both true then
my field gets populated with True.

I can then format the text in the "description" cell, by using the True or
False value in the cell already calculated.

Thanks for your help.
--
Dave Eade
EPCS Ltd
www.EPCS.me.uk

"John Moore" wrote:

Hi Dave, I'm not sure I am understanding what you want to do next

"Dave Eade" wrote:

Hi John,
Thanks for that.

I got about as far as the testing the date against "todays Date", what I
need to do is have multiple conditions:

I guess it read like

If B2 < A1 AND
C2 does not = "yes"
Then True
Else False

It's the combination bit I'm struggling with.

Thanks

--
Dave Eade
EPCS Ltd
www.EPCS.me.uk

"John Moore" wrote:

Dave, sounds like you need to us the IF statement ,,, something like this

=if(B2<A$1,"",NO).... assumption that todays date is in A1 and the task
completion date is in B2
then just conditional format to show whatever you want.

"Dave Eade" wrote:

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