Excel calculate time between dates and prompt reminder

[SJ1]

Hi There

Can anybody help me. I am trying to run a spreadsheet that deals with expiry dates and prompts a reminder and/or highlights the field with a colour, when the renewal date is within the next 30 - 60 Days from the current date. In addition, I need the cell to turn a different colour if this has now become overdue.

Many Thanks

Sue

 

[Derek Brown]

You need to use Conditional Formatting. You will find examples at:
http://www.contextures.com/xlcondformat03.html