Hello:
I'm trying to apply conditional formatting depending on where the value
falls within a date range.

If cell S2 is < 06/28/09 - color the cell in red
If cell S2 is = 09/28/09 - leave the cell without any color
If cell S2 is = 06/29/09 and <= 09/27/09 color the cell in green.

I've tried to put it into conditional formatting but it changes the color of
every cell to red. Here is what I did, please advise, I think it must
something to do with date...

Formula is =S2<"06/28/09" (format red)
Formula is =S2="09/28/09" (format none)
Formula is =AND(S2="06/29/09",S2<="09/27/09") (format green)

Please help.
Monika