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.