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. Please consider the environment before printing this email.
Conditional Formatting.xls
Description: MS-Excel spreadsheet