Dear Pak Odong Nando,
Terima kasih bnyak Pak atas masukkannya...Nti coba saya coba saran Pak Odong Nando... Ini komputer kantor Pak...jadi maunya yg gratis2an aja... Klo msih g berhasil nti saya tanya2 lagi yaa... Terima kasih... Best regards, Fendik Anton Wijaya PT. Toyota Astra Financial Services Gedung GARDA OTO Jl. A. Yani KM. 3.5 No. 66 Banjarmasin 70369 Telpon : 0511.3269136 Handphone : 085751196989 From: mailto:belajar-excel@yahoogroups.com Sent: Friday, August 14, 2015 11:01 AM To: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Conditional formating tgl jatuh tenpo dear fendik, saran saya coba buka data yang anda input di open office dengan excel 2003 keatas alias excel 2007 atau yang terbaru. karena excel 2003 atau yang terdahulunya masih sangat membatasi penggunaan fungsi IF. dan coba save As dengan extensi .xlsx untuk conditional formating sepertinya hanya kondisi yang sangat sederhana saja yang mampu di baca oleh kedua jenis spradsheet tersebut, dan saran saya apa bila anda bersih kukuh untuk menggunakan aplikasi gratis, dalam hal ini spradsheet open office, maka gunakan WPS office / kingsoft office versi terbaru, karena aplikasi gratis yang paling mendekati excel sepanjang pengalaman saya ya hanya WPS office / kingsoft office. memang tidak semua conditional formating yang di buat pada spredsheet WPS office / kingsoft office dapat di buka dengan sempurna dengan excel, tapi saya yakin, bila kasusnya seperti yang pak fendik lampirkan tersebet maka pembuatan conditional formating pada WPS office / kingsoft office dapat dibuka dengan sempurna di excel pak fendik. note : aplikasi grasit WPS office / kingsoft office, tidak mendukung VBA macro. thx, odong nando Pada Rabu, 12 Agustus 2015 18:49, "'Fendik Anton Wijaya' fendik.an...@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Dear Para suhu, Assalamuallaikum wr.wb. Mohon penjelasan & pencerahannya kenapa ya database saya open office saat saya buka pake excel malah ada rumus yg g kebaca... Jadi ada yg error atau #NA() dan kalo saya copy paste kan rumusnya dari open office ke excel kebaca #value!... Trus rumus formula conditional formatting saya jg berantakan saat database saya buka di excel... Jadi saat data itu saya buka pake open office formula conditional formating baik2 saja tpi saat saya buka pake excel malah g ngebaca formulanya... Berikut terlampir database dlm excel & open office... Mohon bantuannya Master... Terima kasih atas bantuan & pencerahannya para master... Best regards, Fendik Anton Wijaya -------------------------------------------------------------------------------- The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message. ý Towards a Sustainable Future - Please consider the environment before printing this email. ------------------- The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message. Please consider the environment before printing this email.