If I understood your problem correctly, highlight C1 and setup the CF by
selecting 'between' then the two ranges A1 and B1 then format as green. Click
Add and this time select 'Not between' from the dropdown list then click on
both A1 and B1 consecutively then highlight Red.

H.T.H.
--
when u change the way u look @ things, the things u look at change.


"Lynn" wrote:

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