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
|