salam excel, menyambung jawaban pak agung, maybe alert bisa memakai conditional formatting, ketikan pada bagian 'Format only cells that contain - pilih format only cell dengan "cell value" - between - = today() and =today()+7 (misal alert untuk 1 minggu sebelumnya) untuk lebih jelasnya saya sertakan filenya.
-snupy- ________________________________ Dari: "[email protected]" <[email protected]> Kepada: [email protected] Dikirim: Rabu, 5 September 2012 10:06 Judul: RE: [belajar-excel] Mencari tanggal akhir kontrak Menurut saya Alert hanya akan bisa dilihat bila file dibuka, CMIIW Mungkin bisa dengan conditional formatting-formula jika tanggal jatuh tempo di sel tiba atau lebih besar dari today(), maka pattern / font berubah warna. Wassalam Agung Widodo ________________________________ From:[email protected] [mailto: [email protected] ] On Behalf Of Joe Dien Sent: Wednesday, September 05, 2012 9:50 AM To: [email protected] Subject: Bls: [belajar-excel] Mencari tanggal akhir kontrak Dear Be Excell..... Menyambung dari pertanyaan Mba Aini, bagaimana caranya memunculkan alert/tanda di PC/excell untuk 1 minggu/bulan sebelumnya dari akhir kontrak tersebut. Atas perhatiannya be exceller diucapkan terima kasih. Joedien "Keep Smiling n Spirit" ________________________________ Dari:Bagus <[email protected]> Kepada: [email protected] Dikirim: Selasa, 4 September 2012 16:13 Judul: Re: [belajar-excel] Mencari tanggal akhir kontrak Dear Alni; pada cell C5 ketik formula berikut: =edate(B5,24)-1 Bagus ----- Original Message ----- >From:Alni Mainora >To:[email protected] >Sent:Tuesday, September 04, 2012 3:22 PM >Subject:[belajar-excel] Mencari tanggal akhir kontrak > > >Salam para pakar Excel, > >mohon dicarikan solusi, >Jika ada karyawan yang join tgl 04 September 2012 dan 2 tahun kedepan >kontraknya akan berakhir, bagaimana cara bikin formulanya ? >Contoh data terlampir. > >Terima kasih banyak atas solusinya. > >Wassalam, > >Alni Mainora > >THIS CORRESPONDENCE CONTAINS CONFIDENTIAL INFORMATION OF KEMET ELECTRONICS CORPORATION AND ITS AFFILIATED COMPANIES. If you have received this e-mail and it was not intended for you, please let us know, and then delete it. We thank you for treating our confidential information in a courteous and professional manner. > >DISCLAIMER: Although we have taken reasonable steps to reduce risks against viruses, the reliability of this method of communication cannot be guaranteed. It can be intercepted, corrupted, or delayed, or it may arrive incomplete, contain viruses, or be affected by other interference. The opening of any attachments to this e-mail indicates your agreement to hold us harmless and release us from liability for any damage sustained as a result of this transmission.
cond format akhir kontrak.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
