Conditional Formatting relating to dates

Hi all

I'm attempting to set up a record of contracts via excel.

I'd like to implement a cell that serves as a reminder for whether or not action should be taken depending on the date and end of contract date (ie more than 12 months left = green, 12 to 9 months left = amber, 9 - 6 months left = red).

Any ideas as to how I can build a formula that will look at the end contract date and determine conditional formatting for the cell U6?

Much appreciated.

Hope this helps!!

That works...why didn't I think of that, great simple solution?!

Thanks Vinodsralian.