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.
|