Dear Mr. Kid,
Waaao berhasil Pak... Terima kasih banyak Mr. Kid... Best regards, Fendik Anton Wijaya PT. Toyota Astra Financial Services Gedung GARDA OTO Jl. A. Yani KM. 3.5 No. 66 Banjarmasin 70369 VOIP : 1929 EXT. 118 Telpon : 0511.3269136 Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Tuesday, November 24, 2015 9:06 PM To: BeExcel Subject: Re: [belajar-excel] Conditional Formatting Hai Fendik, Blok area yang akan diberi Conditional Formatting (CF) mulai dari record pertamanya (misal data di kolom C). Kemudian buat CF dengan opsi is formula (xl2007 ke atas) atau formula is (xl2003 ke bawah). Tulis formula kondisinya, seperti : (untuk baris 5) =$F5>0 kemudian atur formatnya dan OK sampai kembali ke worksheet Regards, Kid On Tue, Nov 24, 2015 at 8:29 AM, 'Fendik Anton Wijaya' fendik.an...@tafinance.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Semangat Pagi para master/guru2, Mohon bantuannya apa ya rumusnya conditional formatting agar hanya kolom tertentu yg berwarna merah jika nilai kolom lain mempunyai angka > 0.. Misal kolom C5:C12, jadi hanya kolom tertentu yg berwarna merah jika ada kolom F5:F12 yg mempunyai nilai > 0... Berikut saya lampirkan contoh excelnya... Mohon bantuannya & pencerahannya para master & guru2... Terima kasih banyak atas bantuannya... Best regards, Fendik Anton Wijaya PT. Toyota Astra Financial Services Gedung GARDA OTO Jl. A. Yani KM. 3.5 No. 66 Banjarmasin 70369 VOIP : 1929 EXT. 118 Telpon : 0511.3269136 Handphone : 081351356550 ------------------------------------------------------------------------------ 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.
