Conditional Formatting - dates that equal to one particular date

Hi guys,

In cell A1 i have a "hardcoded" date & time in the following format: 2011-06-10 02:00
In the rest of the sheet I have various dates like:

2011-06-11 01:00
2011-06-10 04:00
2011-06-09 12:00
etc.

I am trying to make some conditional formatting:
Every cell that has the same date as cell A1 (indifferent of time) is highlighted green.
Every cell that has a date that is A1 minus 1 day is highlighted red.
Every cell that has a date that is A1 plus 1 day is highlighted yellow.

I have been sweating all evening over this - could someone with skills help?
Thank you!!!

Select the range of dates to check.

Go to Home|Conditional Formatting|Manage Rules

Select New Rule and then use a formula to determine which cells to format.

Then enter formula

=INT(B1)=INT($A$1)

where B1 is top most cell you selected to format

Click Format and choose Green from the Fill tab.

Click Ok,

Click New Rule and repeat with formula:

=INT(B1)=INT($A$1)-1

Format as Red

and repeat with formula

=INT(B1)=INT($A$1)+1

format as yellow.