[belajar-excel] Digest Number 3635

Milis Belajar Microsoft Excel Group

2 Messages

Digest #3635

1a

Bls: [belajar-excel] Conditional formating [1 Attachment] by "odong nando"

2a

Re: Conditional formating by "Sri Wahyudi"

Messages

1a

Bls: [belajar-excel] Conditional formating [1 Attachment]

Tue Nov 10, 2015 1:55 am (PST) . Posted by:

"odong nando"

blok bagian yang akan di pasang conditional formatirng, masuk conditional formating, |->new rule,|-> use formula to..., isi format value .... dengan :
=($K3="")*($J3<>"")*($I3<>"")

br,

odong nando


Pada Selasa, 10 November 2015 16:23, "Sri Wahyudi SWahyudi@pacbrands.com.au [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  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 #yiv5801568191 #yiv5801568191 -- #yiv5801568191ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5801568191 #yiv5801568191ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5801568191 #yiv5801568191ygrp-mkp #yiv5801568191hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5801568191 #yiv5801568191ygrp-mkp #yiv5801568191ads {margin-bottom:10px;}#yiv5801568191 #yiv5801568191ygrp-mkp .yiv5801568191ad {padding:0 0;}#yiv5801568191 #yiv5801568191ygrp-mkp .yiv5801568191ad p {margin:0;}#yiv5801568191 #yiv5801568191ygrp-mkp .yiv5801568191ad a {color:#0000ff;text-decoration:none;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ygrp-lc {font-family:Arial;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ygrp-lc #yiv5801568191hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ygrp-lc .yiv5801568191ad {margin-bottom:10px;padding:0 0;}#yiv5801568191 #yiv5801568191actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5801568191 #yiv5801568191activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5801568191 #yiv5801568191activity span {font-weight:700;}#yiv5801568191 #yiv5801568191activity span:first-child {text-transform:uppercase;}#yiv5801568191 #yiv5801568191activity span a {color:#5085b6;text-decoration:none;}#yiv5801568191 #yiv5801568191activity span span {color:#ff7900;}#yiv5801568191 #yiv5801568191activity span .yiv5801568191underline {text-decoration:underline;}#yiv5801568191 .yiv5801568191attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5801568191 .yiv5801568191attach div a {text-decoration:none;}#yiv5801568191 .yiv5801568191attach img {border:none;padding-right:5px;}#yiv5801568191 .yiv5801568191attach label {display:block;margin-bottom:5px;}#yiv5801568191 .yiv5801568191attach label a {text-decoration:none;}#yiv5801568191 blockquote {margin:0 0 0 4px;}#yiv5801568191 .yiv5801568191bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5801568191 .yiv5801568191bold a {text-decoration:none;}#yiv5801568191 dd.yiv5801568191last p a {font-family:Verdana;font-weight:700;}#yiv5801568191 dd.yiv5801568191last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5801568191 dd.yiv5801568191last p span.yiv5801568191yshortcuts {margin-right:0;}#yiv5801568191 div.yiv5801568191attach-table div div a {text-decoration:none;}#yiv5801568191 div.yiv5801568191attach-table {width:400px;}#yiv5801568191 div.yiv5801568191file-title a, #yiv5801568191 div.yiv5801568191file-title a:active, #yiv5801568191 div.yiv5801568191file-title a:hover, #yiv5801568191 div.yiv5801568191file-title a:visited {text-decoration:none;}#yiv5801568191 div.yiv5801568191photo-title a, #yiv5801568191 div.yiv5801568191photo-title a:active, #yiv5801568191 div.yiv5801568191photo-title a:hover, #yiv5801568191 div.yiv5801568191photo-title a:visited {text-decoration:none;}#yiv5801568191 div#yiv5801568191ygrp-mlmsg #yiv5801568191ygrp-msg p a span.yiv5801568191yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5801568191 .yiv5801568191green {color:#628c2a;}#yiv5801568191 .yiv5801568191MsoNormal {margin:0 0 0 0;}#yiv5801568191 o {font-size:0;}#yiv5801568191 #yiv5801568191photos div {float:left;width:72px;}#yiv5801568191 #yiv5801568191photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5801568191 #yiv5801568191photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5801568191 #yiv5801568191reco-category {font-size:77%;}#yiv5801568191 #yiv5801568191reco-desc {font-size:77%;}#yiv5801568191 .yiv5801568191replbq {margin:4px;}#yiv5801568191 #yiv5801568191ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5801568191 #yiv5801568191ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5801568191 #yiv5801568191ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5801568191 #yiv5801568191ygrp-mlmsg select, #yiv5801568191 input, #yiv5801568191 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5801568191 #yiv5801568191ygrp-mlmsg pre, #yiv5801568191 code {font:115% monospace;}#yiv5801568191 #yiv5801568191ygrp-mlmsg * {line-height:1.22em;}#yiv5801568191 #yiv5801568191ygrp-mlmsg #yiv5801568191logo {padding-bottom:10px;}#yiv5801568191 #yiv5801568191ygrp-msg p a {font-family:Verdana;}#yiv5801568191 #yiv5801568191ygrp-msg p#yiv5801568191attach-count span {color:#1E66AE;font-weight:700;}#yiv5801568191 #yiv5801568191ygrp-reco #yiv5801568191reco-head {color:#ff7900;font-weight:700;}#yiv5801568191 #yiv5801568191ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ov li a {font-size:130%;text-decoration:none;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5801568191 #yiv5801568191ygrp-sponsor #yiv5801568191ov ul {margin:0;padding:0 0 0 8px;}#yiv5801568191 #yiv5801568191ygrp-text {font-family:Georgia;}#yiv5801568191 #yiv5801568191ygrp-text p {margin:0 0 1em 0;}#yiv5801568191 #yiv5801568191ygrp-text tt {font-size:120%;}#yiv5801568191 #yiv5801568191ygrp-vital ul li:last-child {border-right:none !important;}#yiv5801568191

Reply to sender . Reply to group . Reply via Web Post . All Messages (17) . Top ^

2a

Re: Conditional formating

Tue Nov 10, 2015 2:18 am (PST) . Posted by:

"Sri Wahyudi"

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
swahyudi@pacbrands.com.au mailto:mwidawati@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 SWahyudi@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

Reply to sender . Reply to group . Reply via Web Post . All Messages (17) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use