Another Conditional Formatting Question

[Gsa]

Hi,

I could do with a bit of help please. I'm using excel 2010 and I have a simple sheet that has dates in it and I use the following to change the cell colour, Blank, Red, Green

=E3=""
=ABS(E3-TODAY())<=27
=ABS(E3-TODAY())<=56

That is Ok, for future dates but what i would like is that if the date is in the past that it goes say blue.

I would also like somehow to just print out the red items.

Any ideas?

Thanks

John