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