Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.

Conditional Formatting Based on Date
 

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.