Excel maintains dates as numbers. The COUNT function is verifying that there
are 2 numbers, one in A1 and one in B1 and if there are, it compares C1 to
see if it is in range of the numbers (dates) in A1 and B1.

Tyro

"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