Sheet1Denumire clientData de expirare contractclient 118-Mar-15client 219-Mar-15client 320-Mar-15client 421-Mar-15client 522-Mar-15client 623-Mar-15client 724-Mar-15client 825-Mar-15Pasul 1 - La tabelul tau in care ai coloana A"Denumire client" si coloana B " data de expirare contract" mai adaugi o coloana, coloana C "Data de azi". Tabelul va arata ca mai josDenumire clientData de expirare contractData de aziclient 118-Mar-155/20/15client 219-May-155/20/15client 320-Mar-155/20/15client 421-Apr-155/20/15client 522-Mar-155/20/15 client 623-Jun-155/20/15client 724-Mar-155/20/15client 825-Apr-155/20/15Pasul 2 -Se mai adauga o coloana, coloana D "Stare contract". In celula D14 se va adauga o noua functie care sa verifice daca data din coloana B, este aceeasi sau mai mare dacat data din coloana C, si sa ma avertizeze daca contractul este expirat. pentru aceasta voi folosi functia IF.Denumire clientData de expirare contractData de azi Stare contractclient 118-Mar-155/20/15valabilclient 219-May-155/20/15valabilclient 320-Mar-155/20/15valabilclient 421-Apr-155/20/15valabilclient 522-Mar-155/20/15valabilclient 623-Jun-155/20/15expiratclient 724-Mar-155/20/15valabilclient 825-Apr-155/20/15valabilPasul 3 - As vrea sa-mi coloreze in rosu contractele expirate. Pentru aceasta folosesc " Conditional Formating" si dau "New Rule"

In celula C14 se insereaza functia TODAYIn celula D26 se insereaza functia IF

Sheet2

Sheet3