Conditional Formatting question

Hi all,

New to the forum and just after some help if possible.

Firstly I'm not sure what I want to do can be done but here goes:

Basically I have a spreadsheet set up as a diary and what I wanted to do was in a particular cell (ie B4) I enter a due date and if this due date is less than 5 days away the cell turns red, if the due date is 5-10 days away the cell turns orange and longer than that the cell either remain clear or if possible turns green.

Like I said not sure if this can be achieved, but someone on here will know so thanks in advance.

Clive

Thanks Jeff, looks great I'll delve deeper and get back to you.

Absolutely brilliant. Just a few tweaks and its sorted.

Thanks again Jeff