RE: [belajar-excel] Conditional formating

[Sri Wahyudi swahy...@pacbrands.com.au [belajar-excel]]

Waduh kok belum berhasil ya pak?
  
  
 Sri Wahyudi | Costing | Pacific Brands Indonesia
 Kawasan Industri Jababeka Jl Jababeka XII B Blok W No 39 Cikarang 17530 
INDONESIA
 Phone  
 +62218937273 ext 111
 Mobile  
 +6285642071206
 Email  
 swahy...@pacbrands.com.au mailto:mwidaw...@pacbrands.com.au
 www.pacificbrands.com.au http://www.pacificbrands.com.au/
 https://twitter.com/pacbrandsjobs 
http://www.linkedin.com/company/pacific-brands
 http://www.pacificbrands.com.au/
 
  
 From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] 
 Sent: Tuesday, 10 November 2015 4:30
 To: belajar-excel@yahoogroups.com
 Subject: Re: [belajar-excel] Conditional formating
 
 
  
   
 
 
 
 السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ Semangat pagi,.    Sambil 
menunggu para Suhu,    Mungkin bisa gini :    = If ( And ( Cell_K_Blank ; 
Cell_I_NonBlank ; Cell_J_NonBlank ) )          وَالسَّلَامُ عَلَيْكُمْ 
وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ    Warm Regards, On 10/11/2015 16:11, Sri 
Wahyudi swahy...@pacbrands.com.au [belajar-excel] wrote:
 
   
 Dear Master Excell
  
 Mohon pencerahannya untuk kasus conditional formatting, seperti file yang 
terlampir,
 Saya ingin membuat suatu kondisional formatting dengan gabungan IF namun masih 
minim jam terbang, 
  
  
 Trims
  
 Yudi