Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

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

"LiveUser" wrote:

Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

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

"LiveUser" wrote in message
...
Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"LiveUser" wrote in message
...
Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

David neither of the formula's worked.

"David Biddulph" wrote:

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"LiveUser" wrote in message
...
Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

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

"David Biddulph" wrote:

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"LiveUser" wrote in message
...
Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.

Thanks for letting us know.
--
David Biddulph

"LiveUser" wrote in message
...
I'm Sorry, They did work... Thank you...

"David Biddulph" wrote:

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"LiveUser" wrote in message
...
Here are my conditions:

1.)Turns cell orange =AND(E10<"",E$1<"",E10E$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<"",E10E$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.