I think code is your solution, it is not easy (possible) to keep track in CF
where the last colour was used.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks, but don't want to alternate, know how to do that. i need to each
group
of the same dates one color, then the next group the other color

1/2/2007 <- blue
1/2/2007<- blue
1/2/2007<- blue
1/4/2007<- white
1/4/2007<- white
1/4/2007<- white
1/4/2007<- white
1/7/2007<- blue (days skipped here as not every date will be entered)


--


Gary


"galimi" wrote in message
...
Gary,

I have placed a spreadsheet at http://www.HelpExcel.com/examples. The
name
is alternate.xls
--
http://HelpExcel.com




"Gary Keramidas" wrote:

what would the 2 formulas be to alternate cell colors in the date
groups?

1/2/2007
1/2/2007
1/2/2007
1/4/2007
1/4/2007
1/4/2007
1/4/2007
1/5/2007


--


Gary