You don't need to go through that intermediate step of calculating a TRUE or
FALSE in a cell and using that in CF.
In CF, use Formula Is, rather than Cell Value Is, and put your formula
=AND(...,...)
--
David Biddulph
"Dave Eade" wrote in message
...
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