Conditional formats in Excel 2003 and earlier are tested sequentially, and
as soon as one conditional format is applied, the others are ignored. But
there may be mo

Which cell is this the format for, B6 or B9?
What is the default format of the cell?
What is a typical value of B9?
Is it really a date, or does Excel interpret is as text (i.e., numerical
value of zero, which is less than today's date)?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jarod" wrote in message
...
I have 3 Conditional Format Formulas, 1 of which is not allowing the other
to
be applied. Here are the formulas:

#1 =ISBLANK($B$6) - no format
#2 =$B$9<=(TODAY()+3) - orange fill
#3 =$B$9<=(TODAY()+7) - yellow fill

When the cell shows within 3 days, the cell is orange. It remains orange
when the date is moved past 3 days as well. I've tried reversing the
order
of the formulas and colors, but that results in the fill being yellow,
regardless of the days.

Is it a conflict between the formulas? I can't think of a better way to
write them.