Date Range Conditional Formatting
I don't think you would want any format applied unless you have all 3 dates
entered.
With that in mind then we should change the formulas if you're formatting
the fill color:
Condition 1:
=AND(COUNT(A1:C1)=3,C1=A1,C1<=B1)
Condition 2:
=AND(COUNT(A1:C1)=3,OR(C1<A1,C1B1))
If you're formatting the font color then the original formulas will be ok.
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
It's making sure that there are 2 dates entered in both A1 and B1.
Depending on your use you may not need it in there but it won't hurt
anything.
For example, with condition 1, if A1 is empty but both B1 and C1 contain
certain dates the format will be applied.
With condition 2, if B1 is empty but both A1 and C1 conatin certain dates
the format will be applied.
I don't think you would want any format applied unless you have all 3
dates entered.
--
Biff
Microsoft Excel MVP
"Lynn" wrote in message
...
How does the COUNT function apply here?
--
-Lynn F. PMP
"T. Valko" wrote:
Select cell C1
Goto FormatConditional Formatting
Condition 1
Formula Is: =AND(COUNT(A1,B1)=2,C1=A1,C1<=B1)
Click the Format button
Select the desired style(s)
OK
Click the Add button
Condition 2
Formula Is: =AND(COUNT(A1,B1)=2,OR(C1<A1,C1B1))
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"Lynn" wrote in message
...
Help! I can't get the following to work & I haven't been able to find
the
solution in this discussion group.
A1 = 1/16/08
B1 = 2/6/08
I want C1 to be green if it contains a date between the dates in A1 &
B1
inclusive.
I want C1 to be red if it contains a date that is not between the
dates in
A1 & B1
--
-Lynn F. PMP
|