If B6 is non-blank, and B9 is TODAY()+3 but <=TODAY()+7 (for example,
19/5/08), then those CF conditions give a yellow result.
--
David Biddulph

"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.