Conditional formatting cells

[GemMellow]

Hello

I am trying to set up a staff spreadsheet so I can track when the qualifications are due and I cant get my formulas right to change the cells. Our qualifications are renewable yearly so I would like the cells to change to yellow when they are due in 6 months orange when they are due in 3 months and red when they are overdue.
Could someone help with the formulas please?

 

[GemMellow]

Never mind I have logged on the computerand found it.

http://www.dropbox.com/h

 

[tyija1995]

Hey that link didn't work - try going to the test section and pasting the link on there first, does the link you sent work for yourself? it just sends me to the login page for me.