RE: [belajar-excel] Tabel Pengatur Warna [1 Attachment]

2017-08-01 Terurut Topik 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel]
Walaikumsalam warahmatullah Mungkin begini. Sengaja jalannya dibikin 2 , pakai tabel bantu dan conditional formatting, Supaya nambah wawasan. Ade *From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] *Sent:* Tuesday, August 1, 2017 10:41 PM *To:*

Re: [belajar-excel] Tabel Pengatur Warna [1 Attachment]

2017-08-01 Terurut Topik nangagus nanga...@gmail.com [belajar-excel]
Wasalamualaikum warahmatullah, Coba pakai Conditional formating: 1. Letakkan cursor pada C3, pada  Tab Home, Group Styles, KLIk button Conditional Formating. 2. PIlih New rules. 3. KLik Use a formula to determine which cells to format (gambar no 1) 4. Ketik formulanya di tempat: Format