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.* > > >
