Conditional Formatting Based on Date

[LiveUser]

Here are my conditions:

1.)Turns cell orange =AND(E10<>"",E$1<>"",E10>E$1)
2.)Turns cell to no fill =AND(E10<>"",E$1<>"",E10<E$1)
3.)Turns cell red =and("")

I need help on the third condition, =and("").

In E1 I have a week-ending date, in E10 I choose a date.

1.)Turns cell orange =AND(E10<>"",E$1<>"",E10>E$1). If the date I enter in
E10 is after the week-ending date in E1, then the cell turns orange.
2.)Turns cell to no fill =AND(E10<>"",E$1<>"",E10<E$1). If the date I enter
in E10 is before or on the week-ending date in E1, then the cell does not
fill anything.

My third condition is what I need help on:

3.) If the week-ending date has not arrived, then do nothing, but if the
week-ending date has arrived and no date has been entered, then color the
cell red.

Thank you.

 

[LiveUser]

It looks like, based on what I want, I may need help on the second condition
also.

 

[David Biddulph]

Perhaps you want =AND(E$1<=TODAY(),E10="") for your red condition.
By default the cell would have no fill (unless you've got a fill colour in
your normal cell formatting), so you may not need your second condition.

 

[David Biddulph]

Or (for your red condition)
=AND(E$1<>"",E$1<=TODAY(),E10="")
to protect against E$1 being empty.

 

[LiveUser]

David neither of the formula's worked.

Or (for your red condition)
=AND(E$1<>"",E$1<=TODAY(),E10="")
to protect against E$1 being empty.

 

[LiveUser]

I'm Sorry, They did work... Thank you...

Or (for your red condition)
=AND(E$1<>"",E$1<=TODAY(),E10="")
to protect against E$1 being empty.

 

[David Biddulph]

Thanks for letting us know.
--
David Biddulph

I'm Sorry, They did work... Thank you...