How to change the cell Colour when a date has been surpassed?
 

HI,

I need some help with excel.

I currently have a spreadsheet (as attachment) that i use to track incoming orders to our company, what i want is for the cell to change orange when the date (row F) is met i.e if it was due in on the 25/2/2011 and the date was 25/2/11 and then for the cell to change red if the date has been surpassed i.e it was the 26/2/2011.

Any ideas on how i can do this?

Thanks for your time

Brad