Re: [belajar-excel] Formula Menampilkan Warna dengan Conditional Formatting [1 Attachment]

Thu, 23 Apr 2015 22:51:07 -0700 

Coba ini : =IF(COUNTA($A2:$D2)>0,1,0)

tks

Salam,
uharyanto
On 24/04/2015 9:34 AM, Zerlinda Seismica seism...@yahoo.com [belajar-excel] wrote: 
Assalamualaikum wrwb

Mohon bantuan lagi...
Adakah formula di conditional formatting untuk menampilkan warna sesuai dengan kriteria tertentu seperti terlampir... 
semoga para master diberi kemudahan aamiin...

Wassalam
Seimica

Attachment: Formula Menampilkan Warna dengan Conditional Formatting.xlsx
Description: MS-Excel 2007 spreadsheet

  • [belajar-excel] Formu... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
    • Re: [belajar-exc... uharyanto uharya...@gmail.com [belajar-excel]
    • Re: [belajar-exc... Andrie - sioe...@yahoo.com [belajar-excel]
    • Re: [belajar-exc... Andrie - sioe...@yahoo.com [belajar-excel]
      • [belajar-exc... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
        • Re: [bel... Andrie - sioe...@yahoo.com [belajar-excel]
          • RE: ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
            • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
              • ... Heru Safrudin superhe...@gmail.com [belajar-excel]
                • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]
                • ... Heru Safrudin superhe...@gmail.com [belajar-excel]
                • ... Dede pmaho_l...@nabatisnack.co.id [belajar-excel]

Kirim email ke