I'm looking for the correct formulas for the following:

Cell contains a date. Cell must be: colour red up to date entered in cell, colour yellow from date +7 days, colour green from +8 days onwards from date entered in cell.

I understand it involved rules for conditional formatting but the formulas used don't seem to be working.

Thanks very much.