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

"Bob Phillips" wrote:

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" wrote in message
...
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.