Help with Conditional Formatting Formulas

[bradjedis]

Greetings, Any help is greatly appreciated!
Thanks,
Brad


using excel 2007:

I am unclear as how to write these 2 condition formulas.

First Condition:

IF (f16="" and Today() <= e16+7) then no color

Second Condition

IF(f16="" and today() > e16+7) then RED



These are working:

Third Condition

=(F16>E16+7) then Purple

Fourth Condition

=(F16<=E16+7) then Yellow

[HansV]

Use these formulas:

=AND(F16="",TODAY()<=E16+7)

and

=AND(F16="",TODAY()>E16+7)

[bradjedis]

Works for me,


Thanks, Brad