multiple conditions

[jkl]

I have created a conditional format so that a gantt chart shading bars are
created. However, I would like the final cell to be shaded in a separate
color aimed at representing the final due take for the project task.
Conditional formatting appears to allow for two conditions. Do I have to
define the first condition as the more limted one (i.e. the final box in a
different color)? To set up the condition as a forumula (rather than an if
then that returns a True or False in the cell field), what formula can I use?
Thanks in advance.

 

[driller]

Hi jkl,
your question is familiar to some old threads i have read in this forum...if
i still remember

? are the cells in the row contain formulated result of money, or time....
? do you have a column heading something something like by Dates..

so..

1. If the cell contain money values....and you identify the first cell
cond. format

cond.1 formula is = sum("firstcell:thiscell")<"Total Money"
format>patterns>color :

cond.2 formula is = sum("firstcell:thiscell")="Total Money"
format>patterns>color :


2. If the cell contain number of days....and you identify the first cell
cond. format

cond.1 formula is = sum("firstcell:thiscell")<"Total Target Days"
format>patterns>color :

cond.2 formula is = sum("firstcell:thiscell")="Total Target Days"
format>patterns>color :

3. there is another complex one which others from the forum can help you.
MONEY with Real Dates

regards

 

[Bob Phillips]

CF allows 3 conditions.

If any condition is likely to also be true when another condition is met,
then define that as the earlier test.

It is impossible to say what to use without seeing the data, but something
like

=this_date=project_end_date

would be required, no need to IF it as this returns TRUE or FALSE

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[jkl]

Thanks Bob. I went with =AND . . . and used the sequencing like you noted .
.. . worked like a charm!