Conditional Formatting between two dates that are not today!

I know this is fairly easy but I just don't get it!

I would like to change the colour of the date in the second column:
to red if it is more that 7 days from the first column
to green if it 7 days
to blue if it is less than 7 days

Column 1 | Column 2
Sent To Print | PRINTED
1-Jan-14 | 9-Jan-14

Hi and welcome to the forum

Assuming your dates ARE actual dates and not text that looks like dates (test with -isnumber() )
I dont have 2003 here so this is coming from memory and may be off...
go into CF, select USE FORMULA (I think thats what its called there, its the 2nd drop-down in there)
enter =A2+7>B2 format fill RED
select New Rule
repeat the above for =A2+7=B2
A2+7<B2

Take a look at this.

I think you can't count colors that made by conditional format.

No you cant, But another option is to filter on the color and count that.

Also, I didnt really look at your CF rules yet, but maybe you could use countif() based on that?

I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version

say for the first one you can use the same rules as in your conditional format
in sumproduct()
=SUMPRODUCT(--($H$2:$H$17=$F$2:$F$17+56)*($H$2:$H$17<>""))
=SUMPRODUCT(--($H$2:$H$17<$F$2:$F$17+56)*($H$2:$H$17<>""))
=SUMPRODUCT(--($H$2:$H$17>$F$2:$F$17+56)*($H$2:$H$17<>""))
giving
Books approved early 0
Books Approved on time 3
Books approved late: 13