Hi,

I'm trying to create a spreadsheet that a contains a list of projects. I would like to set a formula that will automatically display of how many days before a project expire. The same thing, I would like also to set a color code for 3 levels of warning (purple if the project only have 2 months before deadline, blue if the project only have 1 month before deadline, and Yellow when the project only have 2 weeks before it reached the deadline; and 1 color (Red) for the deadline or out of deadline status when it reached the deadline or went beyond the deadline. Could you help me how to do it?

Thank you and more power!


RedWolf