Gunakan saja conditional formating, ada dimenu format/conditional formating. masukkan kriteria yang diinginkan & pilih warna font atau patern sesuai yang dikehendaki. Untuk excell 2003 terbatas hanya tiga kondisi, untuk excell 2007 bisa lebih banyak lagi. 2009-07-01
hasna sepriansyah encep 2009-07-01 15:52:30 belajar-excel [belajar-excel] IF dengan color Dear Friends, Saya mau buat rumus : jika cell a1 <> 0 maka cell a2 WARNA MERAH, kira2 rumusnya/ penyelesaiannya gmn ya? Thanks sebelumnya Menambah banyak teman sangatlah mudah dan cepat. Undang teman dari Hotmail, Gmail ke Yahoo! Messenger sekarang! http://id.messenger.yahoo.com/invite/ ------------------------------------ bergabung ke milis (subscribe) kirim mail kosong ke: [email protected] posting ke milis kirim kan ke: [email protected] berkunjung ke web milis: http://groups.yahoo.com/group/belajar-excel/ melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ menhubungi moderators & owners: [email protected] keluar dari milis (unsubscribe) kirim mail kosong ke: [email protected] ExcelWeb <http://opi.110mb.com/>Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: mailto:[email protected] mailto:[email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
