[belajar-excel] Fw: Jadwal Pelatihan [1 Attachment]

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Fw: Jadwal Pelatihan [1 Attachment]

hendrik karnadi
Info buat temen2 yang mencari pelatihan Excel bersertifikat.
Salam,HK

Sent from Yahoo Mail on Android
 
  On Thu, Oct 11, 2018 at 0:59, Pelatihan LA LEARNING co<[hidden email]> wrote:  
Jadwal Pelatihan
|  
Jadwal Pelatihan LA LEARNING Bulan OKTOBER 2018
 
LA LEARNING: 0895 3313 69655; 0815-6802589; 021–5577 6954
 
[hidden email]; [hidden email]; [hidden email]
 |
|  |
|  
1
 |  
18 - 19 Okt 18
 |  
Mastering Excel 2010 for Data Processing System
 |
|  
2
 |  
18 - 19 Okt 18
 |  
Powerful Database Analysis Dashboard Reporting With Excel 2010
 |
|  
3
 |  
18 - 19 Okt 18
 |  
Strategic Sourcing & Vendor Management
 |
|  
4
 |  
18 - 19 Okt 18
 |  
Managing Office & Filling  System
 |
|  
5
 |  
22 - 23 Okt 18
 |  
Leadership & Managerial Skill
 |
|  
6
 |  
22 Okt 18
 |  
Digital Marketing
 |
|  
7
 |  
24 Okt 18
 |  
Customer Service Excellence
 |
|  
8
 |  
22 – 23 Okt 18
 |  
Effective Skills for PERSONAL ASSISTANT
 |
|  
9
 |  
23 -24 Okt 18
 |  
Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri ( HPS )
 |
|  
10
 |  
25 - 26 Okt 18
 |  
Effective Communication & Interpersonal Skill
 |
|  
11
 |  
25 - 26 Okt 18
 |  
Manajement Resiko (Risk Management)
 |
|  
12
 |  
26 Okt 18
 |  
POWERPOINT  Do More
 |
|  
13
 |  
29 - 30 Okt 18
 |  
Practical COACHING & COUNSELING
 |
|  
14
 |  
29 - 30 Okt 18
 |  
Problem Solving with LEGO SERIOUS PLAY
 |
|  
15
 |  
30 - 31 Okt 18
 |  
Supply Chain Management
 |
|  
16
 |  
30 - 31 Okt 18
 |  
KPI with Balanced Scored Card
 |


MasteringExcel 2010 for

DataProcessing System

 Kamis - Jum'at, 18– 19 Oktober 2018, Hotel Ibis /MaxOne Menteng Jakarta

TujuanPelatihan
   
   - Peserta memahami cara mengatur wilayah untuk memudahkan proses kerja  
   - Peserta mampu menggunakan operasional numerik dasar pada Microsoft Excel  
   - Peserta mampu mengolah kata dengan fungsi yang ada di Microsoft Excel  
   - Peserta mampu bekerja dengan area kerja dan penamaannya  
   - Peserta mampu melalukan pengurutan data secara cepat.  
   - Peserta mampu melakukan pengolahan data dengan metode pencarian.  
   - Peserta dapat mengenali dan menyusun rumus logika pada pengolahan data  
   - Peserta dapat membedakan dan memisahkan data penting dengan cepat berdasarkan isi data.  
   - Peserta dapat menyaring dan menampilkan spesifik data dengan cepat.  
   - Peserta dapat membuat media input yang aman dan mudah bagi pengguna.  
   - Peserta dapat menyajikan printout data yang cepat, tepat dan nyaman disajikan dengan berbagai metode jenis data.

MateriPelatihan
   
   - Workarea simplify  
   - Printing Technique  
   - Cells and Range Addressing  
   - Arithmatic Operational  
   - String Function  
   - Date Function  
   - Data Sort  
   - Total and SubTotal  
   - Data Search (VlookUp, HLookup)  
   - Remove Duplicates  
   - IF Formula (Beginning)  
   - Conditional Formatting  
   - AutoFilter  
   - Advance Filter  
   - Data Validation  
   - Sparklines  
   - PivotTable & PivotChart

Trainer:Eka Kurniawan

Investasiper Pelatihan

Rp4.000,000per peserta

Atau:mendaftar4 peserta boleh ikut 5 peserta (satu perusahaan yang sama)

Termasuk:Sertifikat, modul, lunch, coffee break,  buku karangan A.M. Lilik Agung.

Tidaktermasuk pajak.

LALEARNING

Jl. Taman Paris 1 no 230 LippoKarawaciTangerang. Telp/Fax.:(021) 55776954


Message sent with an unregistered version of MailList King!
MailList King: Powerful mailing list management from your desktop.
Xequte Software - www.xequte.com



|  | Virus-free. www.avast.com  |

   

Untitled (53K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]

Hilman
Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman#yiv8265176273 #yiv8265176273 -- #yiv8265176273ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8265176273 #yiv8265176273ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8265176273 #yiv8265176273ygrp-mkp #yiv8265176273hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8265176273 #yiv8265176273ygrp-mkp #yiv8265176273ads {margin-bottom:10px;}#yiv8265176273 #yiv8265176273ygrp-mkp .yiv8265176273ad {padding:0 0;}#yiv8265176273 #yiv8265176273ygrp-mkp ..yiv8265176273ad p {margin:0;}#yiv8265176273 #yiv8265176273ygrp-mkp .yiv8265176273ad a {color:#0000ff;text-decoration:none;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc {font-family:Arial;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc #yiv8265176273hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc .yiv8265176273ad {margin-bottom:10px;padding:0 0;}#yiv8265176273 #yiv8265176273actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8265176273 #yiv8265176273activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8265176273 #yiv8265176273activity span {font-weight:700;}#yiv8265176273 #yiv8265176273activity span:first-child {text-transform:uppercase;}#yiv8265176273 #yiv8265176273activity span a {color:#5085b6;text-decoration:none;}#yiv8265176273 #yiv8265176273activity span span {color:#ff7900;}#yiv8265176273 #yiv8265176273activity span .yiv8265176273underline {text-decoration:underline;}#yiv8265176273 .yiv8265176273attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8265176273 .yiv8265176273attach div a {text-decoration:none;}#yiv8265176273 .yiv8265176273attach img {border:none;padding-right:5px;}#yiv8265176273 .yiv8265176273attach label {display:block;margin-bottom:5px;}#yiv8265176273 .yiv8265176273attach label a {text-decoration:none;}#yiv8265176273 blockquote {margin:0 0 0 4px;}#yiv8265176273 .yiv8265176273bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8265176273 .yiv8265176273bold a {text-decoration:none;}#yiv8265176273 dd.yiv8265176273last p a {font-family:Verdana;font-weight:700;}#yiv8265176273 dd.yiv8265176273last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8265176273 dd.yiv8265176273last p span.yiv8265176273yshortcuts {margin-right:0;}#yiv8265176273 div.yiv8265176273attach-table div div a {text-decoration:none;}#yiv8265176273 div.yiv8265176273attach-table {width:400px;}#yiv8265176273 div.yiv8265176273file-title a, #yiv8265176273 div.yiv8265176273file-title a:active, #yiv8265176273 div.yiv8265176273file-title a:hover, #yiv8265176273 div.yiv8265176273file-title a:visited {text-decoration:none;}#yiv8265176273 div.yiv8265176273photo-title a, #yiv8265176273 div.yiv8265176273photo-title a:active, #yiv8265176273 div.yiv8265176273photo-title a:hover, #yiv8265176273 div.yiv8265176273photo-title a:visited {text-decoration:none;}#yiv8265176273 div#yiv8265176273ygrp-mlmsg #yiv8265176273ygrp-msg p a span.yiv8265176273yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8265176273 .yiv8265176273green {color:#628c2a;}#yiv8265176273 .yiv8265176273MsoNormal {margin:0 0 0 0;}#yiv8265176273 o {font-size:0;}#yiv8265176273 #yiv8265176273photos div {float:left;width:72px;}#yiv8265176273 #yiv8265176273photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8265176273 #yiv8265176273photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8265176273 #yiv8265176273reco-category {font-size:77%;}#yiv8265176273 #yiv8265176273reco-desc {font-size:77%;}#yiv8265176273 .yiv8265176273replbq {margin:4px;}#yiv8265176273 #yiv8265176273ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8265176273 #yiv8265176273ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8265176273 #yiv8265176273ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8265176273 #yiv8265176273ygrp-mlmsg select, #yiv8265176273 input, #yiv8265176273 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8265176273 #yiv8265176273ygrp-mlmsg pre, #yiv8265176273 code {font:115% monospace;}#yiv8265176273 #yiv8265176273ygrp-mlmsg * {line-height:1.22em;}#yiv8265176273 #yiv8265176273ygrp-mlmsg #yiv8265176273logo {padding-bottom:10px;}#yiv8265176273 #yiv8265176273ygrp-msg p a {font-family:Verdana;}#yiv8265176273 #yiv8265176273ygrp-msg p#yiv8265176273attach-count span {color:#1E66AE;font-weight:700;}#yiv8265176273 #yiv8265176273ygrp-reco #yiv8265176273reco-head {color:#ff7900;font-weight:700;}#yiv8265176273 #yiv8265176273ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov li a {font-size:130%;text-decoration:none;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov ul {margin:0;padding:0 0 0 8px;}#yiv8265176273 #yiv8265176273ygrp-text {font-family:Georgia;}#yiv8265176273 #yiv8265176273ygrp-text p {margin:0 0 1em 0;}#yiv8265176273 #yiv8265176273ygrp-text tt {font-size:120%;}#yiv8265176273 #yiv8265176273ygrp-vital ul li:last-child {border-right:none !important;}#yiv8265176273

Conditional Formating Untuk Baris ganjil dan genap.xlsx (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

Hilman
Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
   
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  #yiv3050217343 #yiv3050217343 -- #yiv3050217343ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3050217343 #yiv3050217343ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3050217343 #yiv3050217343ygrp-mkp #yiv3050217343hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3050217343 #yiv3050217343ygrp-mkp #yiv3050217343ads {margin-bottom:10px;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad {padding:0 0;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad p {margin:0;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad a {color:#0000ff;text-decoration:none;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc {font-family:Arial;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc #yiv3050217343hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc .yiv3050217343ad {margin-bottom:10px;padding:0 0;}#yiv3050217343 #yiv3050217343actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3050217343 #yiv3050217343activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3050217343 #yiv3050217343activity span {font-weight:700;}#yiv3050217343 #yiv3050217343activity span:first-child {text-transform:uppercase;}#yiv3050217343 #yiv3050217343activity span a {color:#5085b6;text-decoration:none;}#yiv3050217343 #yiv3050217343activity span span {color:#ff7900;}#yiv3050217343 #yiv3050217343activity span .yiv3050217343underline {text-decoration:underline;}#yiv3050217343 .yiv3050217343attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3050217343 .yiv3050217343attach div a {text-decoration:none;}#yiv3050217343 .yiv3050217343attach img {border:none;padding-right:5px;}#yiv3050217343 .yiv3050217343attach label {display:block;margin-bottom:5px;}#yiv3050217343 .yiv3050217343attach label a {text-decoration:none;}#yiv3050217343 blockquote {margin:0 0 0 4px;}#yiv3050217343 .yiv3050217343bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3050217343 .yiv3050217343bold a {text-decoration:none;}#yiv3050217343 dd.yiv3050217343last p a {font-family:Verdana;font-weight:700;}#yiv3050217343 dd.yiv3050217343last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3050217343 dd.yiv3050217343last p span.yiv3050217343yshortcuts {margin-right:0;}#yiv3050217343 div.yiv3050217343attach-table div div a {text-decoration:none;}#yiv3050217343 div.yiv3050217343attach-table {width:400px;}#yiv3050217343 div.yiv3050217343file-title a, #yiv3050217343 div.yiv3050217343file-title a:active, #yiv3050217343 div.yiv3050217343file-title a:hover, #yiv3050217343 div.yiv3050217343file-title a:visited {text-decoration:none;}#yiv3050217343 div.yiv3050217343photo-title a, #yiv3050217343 div.yiv3050217343photo-title a:active, #yiv3050217343 div.yiv3050217343photo-title a:hover, #yiv3050217343 div.yiv3050217343photo-title a:visited {text-decoration:none;}#yiv3050217343 div#yiv3050217343ygrp-mlmsg #yiv3050217343ygrp-msg p a span.yiv3050217343yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3050217343 .yiv3050217343green {color:#628c2a;}#yiv3050217343 .yiv3050217343MsoNormal {margin:0 0 0 0;}#yiv3050217343 o {font-size:0;}#yiv3050217343 #yiv3050217343photos div {float:left;width:72px;}#yiv3050217343 #yiv3050217343photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3050217343 #yiv3050217343photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3050217343 #yiv3050217343reco-category {font-size:77%;}#yiv3050217343 #yiv3050217343reco-desc {font-size:77%;}#yiv3050217343 .yiv3050217343replbq {margin:4px;}#yiv3050217343 #yiv3050217343ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3050217343 #yiv3050217343ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3050217343 #yiv3050217343ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3050217343 #yiv3050217343ygrp-mlmsg select, #yiv3050217343 input, #yiv3050217343 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3050217343 #yiv3050217343ygrp-mlmsg pre, #yiv3050217343 code {font:115% monospace;}#yiv3050217343 #yiv3050217343ygrp-mlmsg * {line-height:1.22em;}#yiv3050217343 #yiv3050217343ygrp-mlmsg #yiv3050217343logo {padding-bottom:10px;}#yiv3050217343 #yiv3050217343ygrp-msg p a {font-family:Verdana;}#yiv3050217343 #yiv3050217343ygrp-msg p#yiv3050217343attach-count span {color:#1E66AE;font-weight:700;}#yiv3050217343 #yiv3050217343ygrp-reco #yiv3050217343reco-head {color:#ff7900;font-weight:700;}#yiv3050217343 #yiv3050217343ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov li a {font-size:130%;text-decoration:none;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov ul {margin:0;padding:0 0 0 8px;}#yiv3050217343 #yiv3050217343ygrp-text {font-family:Georgia;}#yiv3050217343 #yiv3050217343ygrp-text p {margin:0 0 1em 0;}#yiv3050217343 #yiv3050217343ygrp-text tt {font-size:120%;}#yiv3050217343 #yiv3050217343ygrp-vital ul li:last-child {border-right:none !important;}#yiv3050217343

   
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

od212
hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     #yiv8074887865 #yiv8074887865 -- #yiv8074887865ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8074887865 #yiv8074887865ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8074887865 #yiv8074887865ygrp-mkp #yiv8074887865hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8074887865 #yiv8074887865ygrp-mkp #yiv8074887865ads {margin-bottom:10px;}#yiv8074887865 #yiv8074887865ygrp-mkp ..yiv8074887865ad {padding:0 0;}#yiv8074887865 #yiv8074887865ygrp-mkp .yiv8074887865ad p {margin:0;}#yiv8074887865 #yiv8074887865ygrp-mkp .yiv8074887865ad a {color:#0000ff;text-decoration:none;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ygrp-lc {font-family:Arial;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ygrp-lc #yiv8074887865hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ygrp-lc .yiv8074887865ad {margin-bottom:10px;padding:0 0;}#yiv8074887865 #yiv8074887865actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8074887865 #yiv8074887865activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8074887865 #yiv8074887865activity span {font-weight:700;}#yiv8074887865 #yiv8074887865activity span:first-child {text-transform:uppercase;}#yiv8074887865 #yiv8074887865activity span a {color:#5085b6;text-decoration:none;}#yiv8074887865 #yiv8074887865activity span span {color:#ff7900;}#yiv8074887865 #yiv8074887865activity span .yiv8074887865underline {text-decoration:underline;}#yiv8074887865 .yiv8074887865attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8074887865 .yiv8074887865attach div a {text-decoration:none;}#yiv8074887865 .yiv8074887865attach img {border:none;padding-right:5px;}#yiv8074887865 .yiv8074887865attach label {display:block;margin-bottom:5px;}#yiv8074887865 .yiv8074887865attach label a {text-decoration:none;}#yiv8074887865 blockquote {margin:0 0 0 4px;}#yiv8074887865 .yiv8074887865bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8074887865 .yiv8074887865bold a {text-decoration:none;}#yiv8074887865 dd.yiv8074887865last p a {font-family:Verdana;font-weight:700;}#yiv8074887865 dd.yiv8074887865last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8074887865 dd.yiv8074887865last p span.yiv8074887865yshortcuts {margin-right:0;}#yiv8074887865 div.yiv8074887865attach-table div div a {text-decoration:none;}#yiv8074887865 div.yiv8074887865attach-table {width:400px;}#yiv8074887865 div.yiv8074887865file-title a, #yiv8074887865 div.yiv8074887865file-title a:active, #yiv8074887865 div.yiv8074887865file-title a:hover, #yiv8074887865 div.yiv8074887865file-title a:visited {text-decoration:none;}#yiv8074887865 div.yiv8074887865photo-title a, #yiv8074887865 div.yiv8074887865photo-title a:active, #yiv8074887865 div.yiv8074887865photo-title a:hover, #yiv8074887865 div.yiv8074887865photo-title a:visited {text-decoration:none;}#yiv8074887865 div#yiv8074887865ygrp-mlmsg #yiv8074887865ygrp-msg p a span.yiv8074887865yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8074887865 .yiv8074887865green {color:#628c2a;}#yiv8074887865 .yiv8074887865MsoNormal {margin:0 0 0 0;}#yiv8074887865 o {font-size:0;}#yiv8074887865 #yiv8074887865photos div {float:left;width:72px;}#yiv8074887865 #yiv8074887865photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8074887865 #yiv8074887865photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8074887865 #yiv8074887865reco-category {font-size:77%;}#yiv8074887865 #yiv8074887865reco-desc {font-size:77%;}#yiv8074887865 .yiv8074887865replbq {margin:4px;}#yiv8074887865 #yiv8074887865ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8074887865 #yiv8074887865ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8074887865 #yiv8074887865ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8074887865 #yiv8074887865ygrp-mlmsg select, #yiv8074887865 input, #yiv8074887865 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8074887865 #yiv8074887865ygrp-mlmsg pre, #yiv8074887865 code {font:115% monospace;}#yiv8074887865 #yiv8074887865ygrp-mlmsg * {line-height:1.22em;}#yiv8074887865 #yiv8074887865ygrp-mlmsg #yiv8074887865logo {padding-bottom:10px;}#yiv8074887865 #yiv8074887865ygrp-msg p a {font-family:Verdana;}#yiv8074887865 #yiv8074887865ygrp-msg p#yiv8074887865attach-count span {color:#1E66AE;font-weight:700;}#yiv8074887865 #yiv8074887865ygrp-reco #yiv8074887865reco-head {color:#ff7900;font-weight:700;}#yiv8074887865 #yiv8074887865ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ov li a {font-size:130%;text-decoration:none;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8074887865 #yiv8074887865ygrp-sponsor #yiv8074887865ov ul {margin:0;padding:0 0 0 8px;}#yiv8074887865 #yiv8074887865ygrp-text {font-family:Georgia;}#yiv8074887865 #yiv8074887865ygrp-text p {margin:0 0 1em 0;}#yiv8074887865 #yiv8074887865ygrp-text tt {font-size:120%;}#yiv8074887865 #yiv8074887865ygrp-vital ul li:last-child {border-right:none !important;}#yiv8074887865

   
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

Hilman
Lupa....Tadi syaratnya tanpa kolom bantu...
hehehe...

      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     #yiv5633965174 #yiv5633965174 -- #yiv5633965174ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5633965174 #yiv5633965174ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5633965174 #yiv5633965174ygrp-mkp #yiv5633965174hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5633965174 #yiv5633965174ygrp-mkp #yiv5633965174ads {margin-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-mkp ..yiv5633965174ad {padding:0 0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad p {margin:0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad a {color:#0000ff;text-decoration:none;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc {font-family:Arial;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc #yiv5633965174hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc .yiv5633965174ad {margin-bottom:10px;padding:0 0;}#yiv5633965174 #yiv5633965174actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5633965174 #yiv5633965174activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5633965174 #yiv5633965174activity span {font-weight:700;}#yiv5633965174 #yiv5633965174activity span:first-child {text-transform:uppercase;}#yiv5633965174 #yiv5633965174activity span a {color:#5085b6;text-decoration:none;}#yiv5633965174 #yiv5633965174activity span span {color:#ff7900;}#yiv5633965174 #yiv5633965174activity span .yiv5633965174underline {text-decoration:underline;}#yiv5633965174 .yiv5633965174attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5633965174 .yiv5633965174attach div a {text-decoration:none;}#yiv5633965174 .yiv5633965174attach img {border:none;padding-right:5px;}#yiv5633965174 .yiv5633965174attach label {display:block;margin-bottom:5px;}#yiv5633965174 .yiv5633965174attach label a {text-decoration:none;}#yiv5633965174 blockquote {margin:0 0 0 4px;}#yiv5633965174 .yiv5633965174bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5633965174 .yiv5633965174bold a {text-decoration:none;}#yiv5633965174 dd.yiv5633965174last p a {font-family:Verdana;font-weight:700;}#yiv5633965174 dd.yiv5633965174last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5633965174 dd.yiv5633965174last p span.yiv5633965174yshortcuts {margin-right:0;}#yiv5633965174 div.yiv5633965174attach-table div div a {text-decoration:none;}#yiv5633965174 div.yiv5633965174attach-table {width:400px;}#yiv5633965174 div.yiv5633965174file-title a, #yiv5633965174 div.yiv5633965174file-title a:active, #yiv5633965174 div.yiv5633965174file-title a:hover, #yiv5633965174 div.yiv5633965174file-title a:visited {text-decoration:none;}#yiv5633965174 div.yiv5633965174photo-title a, #yiv5633965174 div.yiv5633965174photo-title a:active, #yiv5633965174 div.yiv5633965174photo-title a:hover, #yiv5633965174 div.yiv5633965174photo-title a:visited {text-decoration:none;}#yiv5633965174 div#yiv5633965174ygrp-mlmsg #yiv5633965174ygrp-msg p a span.yiv5633965174yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5633965174 .yiv5633965174green {color:#628c2a;}#yiv5633965174 .yiv5633965174MsoNormal {margin:0 0 0 0;}#yiv5633965174 o {font-size:0;}#yiv5633965174 #yiv5633965174photos div {float:left;width:72px;}#yiv5633965174 #yiv5633965174photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5633965174 #yiv5633965174photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5633965174 #yiv5633965174reco-category {font-size:77%;}#yiv5633965174 #yiv5633965174reco-desc {font-size:77%;}#yiv5633965174 .yiv5633965174replbq {margin:4px;}#yiv5633965174 #yiv5633965174ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5633965174 #yiv5633965174ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5633965174 #yiv5633965174ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5633965174 #yiv5633965174ygrp-mlmsg select, #yiv5633965174 input, #yiv5633965174 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5633965174 #yiv5633965174ygrp-mlmsg pre, #yiv5633965174 code {font:115% monospace;}#yiv5633965174 #yiv5633965174ygrp-mlmsg * {line-height:1.22em;}#yiv5633965174 #yiv5633965174ygrp-mlmsg #yiv5633965174logo {padding-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-msg p a {font-family:Verdana;}#yiv5633965174 #yiv5633965174ygrp-msg p#yiv5633965174attach-count span {color:#1E66AE;font-weight:700;}#yiv5633965174 #yiv5633965174ygrp-reco #yiv5633965174reco-head {color:#ff7900;font-weight:700;}#yiv5633965174 #yiv5633965174ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov li a {font-size:130%;text-decoration:none;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov ul {margin:0;padding:0 0 0 8px;}#yiv5633965174 #yiv5633965174ygrp-text {font-family:Georgia;}#yiv5633965174 #yiv5633965174ygrp-text p {margin:0 0 1em 0;}#yiv5633965174 #yiv5633965174ygrp-text tt {font-size:120%;}#yiv5633965174 #yiv5633965174ygrp-vital ul li:last-child {border-right:none !important;}#yiv5633965174

   
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]

Hilman
In reply to this post by od212
Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari pagi nyari2... wkwkwk....

Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     #yiv5633965174 #yiv5633965174 -- #yiv5633965174ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5633965174 #yiv5633965174ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5633965174 #yiv5633965174ygrp-mkp #yiv5633965174hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5633965174 #yiv5633965174ygrp-mkp #yiv5633965174ads {margin-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-mkp ..yiv5633965174ad {padding:0 0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad p {margin:0;}#yiv5633965174 #yiv5633965174ygrp-mkp .yiv5633965174ad a {color:#0000ff;text-decoration:none;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc {font-family:Arial;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc #yiv5633965174hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ygrp-lc .yiv5633965174ad {margin-bottom:10px;padding:0 0;}#yiv5633965174 #yiv5633965174actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5633965174 #yiv5633965174activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5633965174 #yiv5633965174activity span {font-weight:700;}#yiv5633965174 #yiv5633965174activity span:first-child {text-transform:uppercase;}#yiv5633965174 #yiv5633965174activity span a {color:#5085b6;text-decoration:none;}#yiv5633965174 #yiv5633965174activity span span {color:#ff7900;}#yiv5633965174 #yiv5633965174activity span .yiv5633965174underline {text-decoration:underline;}#yiv5633965174 .yiv5633965174attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5633965174 .yiv5633965174attach div a {text-decoration:none;}#yiv5633965174 .yiv5633965174attach img {border:none;padding-right:5px;}#yiv5633965174 .yiv5633965174attach label {display:block;margin-bottom:5px;}#yiv5633965174 .yiv5633965174attach label a {text-decoration:none;}#yiv5633965174 blockquote {margin:0 0 0 4px;}#yiv5633965174 .yiv5633965174bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5633965174 .yiv5633965174bold a {text-decoration:none;}#yiv5633965174 dd.yiv5633965174last p a {font-family:Verdana;font-weight:700;}#yiv5633965174 dd.yiv5633965174last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5633965174 dd.yiv5633965174last p span.yiv5633965174yshortcuts {margin-right:0;}#yiv5633965174 div.yiv5633965174attach-table div div a {text-decoration:none;}#yiv5633965174 div.yiv5633965174attach-table {width:400px;}#yiv5633965174 div.yiv5633965174file-title a, #yiv5633965174 div.yiv5633965174file-title a:active, #yiv5633965174 div.yiv5633965174file-title a:hover, #yiv5633965174 div.yiv5633965174file-title a:visited {text-decoration:none;}#yiv5633965174 div.yiv5633965174photo-title a, #yiv5633965174 div.yiv5633965174photo-title a:active, #yiv5633965174 div.yiv5633965174photo-title a:hover, #yiv5633965174 div.yiv5633965174photo-title a:visited {text-decoration:none;}#yiv5633965174 div#yiv5633965174ygrp-mlmsg #yiv5633965174ygrp-msg p a span.yiv5633965174yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5633965174 .yiv5633965174green {color:#628c2a;}#yiv5633965174 .yiv5633965174MsoNormal {margin:0 0 0 0;}#yiv5633965174 o {font-size:0;}#yiv5633965174 #yiv5633965174photos div {float:left;width:72px;}#yiv5633965174 #yiv5633965174photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5633965174 #yiv5633965174photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5633965174 #yiv5633965174reco-category {font-size:77%;}#yiv5633965174 #yiv5633965174reco-desc {font-size:77%;}#yiv5633965174 .yiv5633965174replbq {margin:4px;}#yiv5633965174 #yiv5633965174ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5633965174 #yiv5633965174ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5633965174 #yiv5633965174ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5633965174 #yiv5633965174ygrp-mlmsg select, #yiv5633965174 input, #yiv5633965174 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5633965174 #yiv5633965174ygrp-mlmsg pre, #yiv5633965174 code {font:115% monospace;}#yiv5633965174 #yiv5633965174ygrp-mlmsg * {line-height:1.22em;}#yiv5633965174 #yiv5633965174ygrp-mlmsg #yiv5633965174logo {padding-bottom:10px;}#yiv5633965174 #yiv5633965174ygrp-msg p a {font-family:Verdana;}#yiv5633965174 #yiv5633965174ygrp-msg p#yiv5633965174attach-count span {color:#1E66AE;font-weight:700;}#yiv5633965174 #yiv5633965174ygrp-reco #yiv5633965174reco-head {color:#ff7900;font-weight:700;}#yiv5633965174 #yiv5633965174ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov li a {font-size:130%;text-decoration:none;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5633965174 #yiv5633965174ygrp-sponsor #yiv5633965174ov ul {margin:0;padding:0 0 0 8px;}#yiv5633965174 #yiv5633965174ygrp-text {font-family:Georgia;}#yiv5633965174 #yiv5633965174ygrp-text p {margin:0 0 1em 0;}#yiv5633965174 #yiv5633965174ygrp-text tt {font-size:120%;}#yiv5633965174 #yiv5633965174ygrp-vital ul li:last-child {border-right:none !important;}#yiv5633965174

   

Conditional Formating Untuk Baris ganjil dan genap.xlsx (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

od212
Ooo...

ternyata syaratnya ganjil dan genap, okelah...
sedikit menyingkat formula yang sudah anda buat...
ganjil  
=ISODD($A1)

genap 
=ISEVEN(IF($A1="";"-";$A1)) 

 br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 13:10
 Judul: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
   
    Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari pagi nyari2... wkwkwk....

Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     

     #yiv4520679981 #yiv4520679981 -- #yiv4520679981ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4520679981 #yiv4520679981ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4520679981 #yiv4520679981ygrp-mkp #yiv4520679981hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4520679981 #yiv4520679981ygrp-mkp #yiv4520679981ads {margin-bottom:10px;}#yiv4520679981 #yiv4520679981ygrp-mkp ..yiv4520679981ad {padding:0 0;}#yiv4520679981 #yiv4520679981ygrp-mkp .yiv4520679981ad p {margin:0;}#yiv4520679981 #yiv4520679981ygrp-mkp .yiv4520679981ad a {color:#0000ff;text-decoration:none;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ygrp-lc {font-family:Arial;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ygrp-lc #yiv4520679981hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ygrp-lc .yiv4520679981ad {margin-bottom:10px;padding:0 0;}#yiv4520679981 #yiv4520679981actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4520679981 #yiv4520679981activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4520679981 #yiv4520679981activity span {font-weight:700;}#yiv4520679981 #yiv4520679981activity span:first-child {text-transform:uppercase;}#yiv4520679981 #yiv4520679981activity span a {color:#5085b6;text-decoration:none;}#yiv4520679981 #yiv4520679981activity span span {color:#ff7900;}#yiv4520679981 #yiv4520679981activity span .yiv4520679981underline {text-decoration:underline;}#yiv4520679981 .yiv4520679981attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4520679981 .yiv4520679981attach div a {text-decoration:none;}#yiv4520679981 .yiv4520679981attach img {border:none;padding-right:5px;}#yiv4520679981 .yiv4520679981attach label {display:block;margin-bottom:5px;}#yiv4520679981 .yiv4520679981attach label a {text-decoration:none;}#yiv4520679981 blockquote {margin:0 0 0 4px;}#yiv4520679981 .yiv4520679981bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4520679981 .yiv4520679981bold a {text-decoration:none;}#yiv4520679981 dd.yiv4520679981last p a {font-family:Verdana;font-weight:700;}#yiv4520679981 dd.yiv4520679981last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4520679981 dd.yiv4520679981last p span.yiv4520679981yshortcuts {margin-right:0;}#yiv4520679981 div.yiv4520679981attach-table div div a {text-decoration:none;}#yiv4520679981 div.yiv4520679981attach-table {width:400px;}#yiv4520679981 div.yiv4520679981file-title a, #yiv4520679981 div.yiv4520679981file-title a:active, #yiv4520679981 div.yiv4520679981file-title a:hover, #yiv4520679981 div.yiv4520679981file-title a:visited {text-decoration:none;}#yiv4520679981 div.yiv4520679981photo-title a, #yiv4520679981 div.yiv4520679981photo-title a:active, #yiv4520679981 div.yiv4520679981photo-title a:hover, #yiv4520679981 div.yiv4520679981photo-title a:visited {text-decoration:none;}#yiv4520679981 div#yiv4520679981ygrp-mlmsg #yiv4520679981ygrp-msg p a span.yiv4520679981yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4520679981 .yiv4520679981green {color:#628c2a;}#yiv4520679981 .yiv4520679981MsoNormal {margin:0 0 0 0;}#yiv4520679981 o {font-size:0;}#yiv4520679981 #yiv4520679981photos div {float:left;width:72px;}#yiv4520679981 #yiv4520679981photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4520679981 #yiv4520679981photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4520679981 #yiv4520679981reco-category {font-size:77%;}#yiv4520679981 #yiv4520679981reco-desc {font-size:77%;}#yiv4520679981 .yiv4520679981replbq {margin:4px;}#yiv4520679981 #yiv4520679981ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4520679981 #yiv4520679981ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4520679981 #yiv4520679981ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4520679981 #yiv4520679981ygrp-mlmsg select, #yiv4520679981 input, #yiv4520679981 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4520679981 #yiv4520679981ygrp-mlmsg pre, #yiv4520679981 code {font:115% monospace;}#yiv4520679981 #yiv4520679981ygrp-mlmsg * {line-height:1.22em;}#yiv4520679981 #yiv4520679981ygrp-mlmsg #yiv4520679981logo {padding-bottom:10px;}#yiv4520679981 #yiv4520679981ygrp-msg p a {font-family:Verdana;}#yiv4520679981 #yiv4520679981ygrp-msg p#yiv4520679981attach-count span {color:#1E66AE;font-weight:700;}#yiv4520679981 #yiv4520679981ygrp-reco #yiv4520679981reco-head {color:#ff7900;font-weight:700;}#yiv4520679981 #yiv4520679981ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ov li a {font-size:130%;text-decoration:none;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4520679981 #yiv4520679981ygrp-sponsor #yiv4520679981ov ul {margin:0;padding:0 0 0 8px;}#yiv4520679981 #yiv4520679981ygrp-text {font-family:Georgia;}#yiv4520679981 #yiv4520679981ygrp-text p {margin:0 0 1em 0;}#yiv4520679981 #yiv4520679981ygrp-text tt {font-size:120%;}#yiv4520679981 #yiv4520679981ygrp-vital ul li:last-child {border-right:none !important;}#yiv4520679981

   
Reply | Threaded
Open this post in threaded view
|

Re: Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

Hilman
Kayaknya harus dibuka file nya dulu om.... hehehe...


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 2:02 PM
 Subject: Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    Ooo...

ternyata syaratnya ganjil dan genap, okelah...
sedikit menyingkat formula yang sudah anda buat....
ganjil  
=ISODD($A1)

genap 
=ISEVEN(IF($A1="";"-";$A1)) 

 br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 13:10
 Judul: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari pagi nyari2... wkwkwk....

Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     

     

     #yiv0340372272 #yiv0340372272 -- #yiv0340372272ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0340372272 #yiv0340372272ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0340372272 #yiv0340372272ygrp-mkp #yiv0340372272hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0340372272 #yiv0340372272ygrp-mkp #yiv0340372272ads {margin-bottom:10px;}#yiv0340372272 #yiv0340372272ygrp-mkp ..yiv0340372272ad {padding:0 0;}#yiv0340372272 #yiv0340372272ygrp-mkp .yiv0340372272ad p {margin:0;}#yiv0340372272 #yiv0340372272ygrp-mkp .yiv0340372272ad a {color:#0000ff;text-decoration:none;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ygrp-lc {font-family:Arial;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ygrp-lc #yiv0340372272hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ygrp-lc .yiv0340372272ad {margin-bottom:10px;padding:0 0;}#yiv0340372272 #yiv0340372272actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0340372272 #yiv0340372272activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0340372272 #yiv0340372272activity span {font-weight:700;}#yiv0340372272 #yiv0340372272activity span:first-child {text-transform:uppercase;}#yiv0340372272 #yiv0340372272activity span a {color:#5085b6;text-decoration:none;}#yiv0340372272 #yiv0340372272activity span span {color:#ff7900;}#yiv0340372272 #yiv0340372272activity span .yiv0340372272underline {text-decoration:underline;}#yiv0340372272 .yiv0340372272attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0340372272 .yiv0340372272attach div a {text-decoration:none;}#yiv0340372272 .yiv0340372272attach img {border:none;padding-right:5px;}#yiv0340372272 .yiv0340372272attach label {display:block;margin-bottom:5px;}#yiv0340372272 .yiv0340372272attach label a {text-decoration:none;}#yiv0340372272 blockquote {margin:0 0 0 4px;}#yiv0340372272 .yiv0340372272bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0340372272 .yiv0340372272bold a {text-decoration:none;}#yiv0340372272 dd.yiv0340372272last p a {font-family:Verdana;font-weight:700;}#yiv0340372272 dd.yiv0340372272last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0340372272 dd.yiv0340372272last p span.yiv0340372272yshortcuts {margin-right:0;}#yiv0340372272 div.yiv0340372272attach-table div div a {text-decoration:none;}#yiv0340372272 div.yiv0340372272attach-table {width:400px;}#yiv0340372272 div.yiv0340372272file-title a, #yiv0340372272 div.yiv0340372272file-title a:active, #yiv0340372272 div.yiv0340372272file-title a:hover, #yiv0340372272 div.yiv0340372272file-title a:visited {text-decoration:none;}#yiv0340372272 div.yiv0340372272photo-title a, #yiv0340372272 div.yiv0340372272photo-title a:active, #yiv0340372272 div.yiv0340372272photo-title a:hover, #yiv0340372272 div.yiv0340372272photo-title a:visited {text-decoration:none;}#yiv0340372272 div#yiv0340372272ygrp-mlmsg #yiv0340372272ygrp-msg p a span.yiv0340372272yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0340372272 .yiv0340372272green {color:#628c2a;}#yiv0340372272 .yiv0340372272MsoNormal {margin:0 0 0 0;}#yiv0340372272 o {font-size:0;}#yiv0340372272 #yiv0340372272photos div {float:left;width:72px;}#yiv0340372272 #yiv0340372272photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0340372272 #yiv0340372272photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0340372272 #yiv0340372272reco-category {font-size:77%;}#yiv0340372272 #yiv0340372272reco-desc {font-size:77%;}#yiv0340372272 .yiv0340372272replbq {margin:4px;}#yiv0340372272 #yiv0340372272ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0340372272 #yiv0340372272ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0340372272 #yiv0340372272ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0340372272 #yiv0340372272ygrp-mlmsg select, #yiv0340372272 input, #yiv0340372272 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0340372272 #yiv0340372272ygrp-mlmsg pre, #yiv0340372272 code {font:115% monospace;}#yiv0340372272 #yiv0340372272ygrp-mlmsg * {line-height:1.22em;}#yiv0340372272 #yiv0340372272ygrp-mlmsg #yiv0340372272logo {padding-bottom:10px;}#yiv0340372272 #yiv0340372272ygrp-msg p a {font-family:Verdana;}#yiv0340372272 #yiv0340372272ygrp-msg p#yiv0340372272attach-count span {color:#1E66AE;font-weight:700;}#yiv0340372272 #yiv0340372272ygrp-reco #yiv0340372272reco-head {color:#ff7900;font-weight:700;}#yiv0340372272 #yiv0340372272ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ov li a {font-size:130%;text-decoration:none;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0340372272 #yiv0340372272ygrp-sponsor #yiv0340372272ov ul {margin:0;padding:0 0 0 8px;}#yiv0340372272 #yiv0340372272ygrp-text {font-family:Georgia;}#yiv0340372272 #yiv0340372272ygrp-text p {margin:0 0 1em 0;}#yiv0340372272 #yiv0340372272ygrp-text tt {font-size:120%;}#yiv0340372272 #yiv0340372272ygrp-vital ul li:last-child {border-right:none !important;}#yiv0340372272

   
Kid
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

Kid
Administrator
In reply to this post by Hilman
Pada ngobrolin apa to...

oh CF untuk id ganjil ya...
karena datanya di-merge ?

Coba ya :
1. blok semua data (baris dan kolom) [mulai dari record pertama ya] -> beri
warna kuning (sebagai genap)
2. semua masih terblok, buat CF untuk ganjil saja (gak perlu buat CF yang
genap), dengan jenis CF : Use formula, isi dengan formula ini : (misal
penentu ganjil genap mulai cells A2, merged)
    =isodd(  lookup( 9^9 , $A$2:$A2 ) )

Sesuaikan cell mulai dalam formula dengan cell kolom penentu ganjil genap
di record pertama.
Moga-moga hasilnya sesuai kebutuhan.

Regards,
Kid







On Thu, Oct 11, 2018 at 1:10 PM Hilman [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Sori... formulanya baru ketemu akhirnya ...
> Alhamdulillah....
> Setelah dari pagi nyari2... wkwkwk....
>
>
> Untuk baris ganjil, pake formula ini...
>
>
> =ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
>
> untuk baris genap,
>
>
> =ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
>
>
>
> ------------------------------
> *From:* "odong nando [hidden email] [belajar-excel]" <
> [hidden email]>
> *To:* "[hidden email]" <[hidden email]>
> *Sent:* Thursday, October 11, 2018 12:30 PM
> *Subject:* Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil
> dan Baris Genap
>
>
> hai hilman,
>
> bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4,
> degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan,
> silakan di coba... [image: *:) senang][image: *:) senang]
>
> br,
>
> odong nando
>
>
> ------------------------------
> *Dari:* "Hilman [hidden email] [belajar-excel]" <
> [hidden email]>
> *Kepada:* "[hidden email]" <[hidden email]>
> *Dikirim:* Kamis, 11 Oktober 2018 10:41
> *Judul:* Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
> Baris Genap
>
>
> Maksudnya...
>
> Gimana caranya conditional formating untuk row yang nilainya 1,3,5
> warnanya akan kuning, sedangkan row 2,4 warnanya hijau..
> Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya
> akan tetap kuning atau tetap hijau….
>
>
>
> ------------------------------
> *From:* "Hilman [hidden email] [belajar-excel]" <
> [hidden email]>
> *To:* "[hidden email]" <[hidden email]>
> *Sent:* Thursday, October 11, 2018 10:40 AM
> *Subject:* [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
> Baris Genap [1 Attachment]
>
>
> Dear All
>
> Gimana caranya conditional formating untuk row yang nilainya 1,3,5
> warnanya akan kuning, sedangkan row 4,5 warnanya hijau..
> Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya
> akan tetap kuning atau tetap hijau….
>
> Makasih yaaa....
>
> Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan
> ternyata jadi gak tajam lagi...
> hehehehe....
>
> Salam
> Hilman
>
>
>
>
>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

Hilman
Dahsyat rumus nya Guru Mr. Kids nih.....
Thanks Mr. Kids...

      From: "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]>
 To: BeExcel <[hidden email]>
 Sent: Thursday, October 11, 2018 3:14 PM
 Subject: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    Pada ngobrolin apa to...
oh CF untuk id ganjil ya...karena datanya di-merge ?
Coba ya :1. blok semua data (baris dan kolom) [mulai dari record pertama ya] -> beri warna kuning (sebagai genap)2. semua masih terblok, buat CF untuk ganjil saja (gak perlu buat CF yang genap), dengan jenis CF : Use formula, isi dengan formula ini : (misal penentu ganjil genap mulai cells A2, merged)    =isodd(  lookup( 9^9 , $A$2:$A2 ) )
Sesuaikan cell mulai dalam formula dengan cell kolom penentu ganjil genap di record pertama.
Moga-moga hasilnya sesuai kebutuhan.
Regards,Kid






On Thu, Oct 11, 2018 at 1:10 PM Hilman [hidden email] [belajar-excel] <[hidden email]> wrote:

     Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari pagi nyari2.... wkwkwk....

Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     

     
  #yiv1349331506 #yiv1349331506 -- #yiv1349331506ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1349331506 #yiv1349331506ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1349331506 #yiv1349331506ygrp-mkp #yiv1349331506hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1349331506 #yiv1349331506ygrp-mkp #yiv1349331506ads {margin-bottom:10px;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad {padding:0 0;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad p {margin:0;}#yiv1349331506 #yiv1349331506ygrp-mkp .yiv1349331506ad a {color:#0000ff;text-decoration:none;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ygrp-lc {font-family:Arial;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ygrp-lc #yiv1349331506hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ygrp-lc .yiv1349331506ad {margin-bottom:10px;padding:0 0;}#yiv1349331506 #yiv1349331506actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1349331506 #yiv1349331506activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1349331506 #yiv1349331506activity span {font-weight:700;}#yiv1349331506 #yiv1349331506activity span:first-child {text-transform:uppercase;}#yiv1349331506 #yiv1349331506activity span a {color:#5085b6;text-decoration:none;}#yiv1349331506 #yiv1349331506activity span span {color:#ff7900;}#yiv1349331506 #yiv1349331506activity span .yiv1349331506underline {text-decoration:underline;}#yiv1349331506 .yiv1349331506attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1349331506 .yiv1349331506attach div a {text-decoration:none;}#yiv1349331506 .yiv1349331506attach img {border:none;padding-right:5px;}#yiv1349331506 .yiv1349331506attach label {display:block;margin-bottom:5px;}#yiv1349331506 .yiv1349331506attach label a {text-decoration:none;}#yiv1349331506 blockquote {margin:0 0 0 4px;}#yiv1349331506 .yiv1349331506bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1349331506 .yiv1349331506bold a {text-decoration:none;}#yiv1349331506 dd.yiv1349331506last p a {font-family:Verdana;font-weight:700;}#yiv1349331506 dd.yiv1349331506last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1349331506 dd.yiv1349331506last p span.yiv1349331506yshortcuts {margin-right:0;}#yiv1349331506 div.yiv1349331506attach-table div div a {text-decoration:none;}#yiv1349331506 div.yiv1349331506attach-table {width:400px;}#yiv1349331506 div.yiv1349331506file-title a, #yiv1349331506 div.yiv1349331506file-title a:active, #yiv1349331506 div.yiv1349331506file-title a:hover, #yiv1349331506 div.yiv1349331506file-title a:visited {text-decoration:none;}#yiv1349331506 div.yiv1349331506photo-title a, #yiv1349331506 div.yiv1349331506photo-title a:active, #yiv1349331506 div.yiv1349331506photo-title a:hover, #yiv1349331506 div.yiv1349331506photo-title a:visited {text-decoration:none;}#yiv1349331506 div#yiv1349331506ygrp-mlmsg #yiv1349331506ygrp-msg p a span.yiv1349331506yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1349331506 .yiv1349331506green {color:#628c2a;}#yiv1349331506 .yiv1349331506MsoNormal {margin:0 0 0 0;}#yiv1349331506 o {font-size:0;}#yiv1349331506 #yiv1349331506photos div {float:left;width:72px;}#yiv1349331506 #yiv1349331506photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1349331506 #yiv1349331506photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1349331506 #yiv1349331506reco-category {font-size:77%;}#yiv1349331506 #yiv1349331506reco-desc {font-size:77%;}#yiv1349331506 .yiv1349331506replbq {margin:4px;}#yiv1349331506 #yiv1349331506ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1349331506 #yiv1349331506ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1349331506 #yiv1349331506ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1349331506 #yiv1349331506ygrp-mlmsg select, #yiv1349331506 input, #yiv1349331506 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1349331506 #yiv1349331506ygrp-mlmsg pre, #yiv1349331506 code {font:115% monospace;}#yiv1349331506 #yiv1349331506ygrp-mlmsg * {line-height:1.22em;}#yiv1349331506 #yiv1349331506ygrp-mlmsg #yiv1349331506logo {padding-bottom:10px;}#yiv1349331506 #yiv1349331506ygrp-msg p a {font-family:Verdana;}#yiv1349331506 #yiv1349331506ygrp-msg p#yiv1349331506attach-count span {color:#1E66AE;font-weight:700;}#yiv1349331506 #yiv1349331506ygrp-reco #yiv1349331506reco-head {color:#ff7900;font-weight:700;}#yiv1349331506 #yiv1349331506ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ov li a {font-size:130%;text-decoration:none;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1349331506 #yiv1349331506ygrp-sponsor #yiv1349331506ov ul {margin:0;padding:0 0 0 8px;}#yiv1349331506 #yiv1349331506ygrp-text {font-family:Georgia;}#yiv1349331506 #yiv1349331506ygrp-text p {margin:0 0 1em 0;}#yiv1349331506 #yiv1349331506ygrp-text tt {font-size:120%;}#yiv1349331506 #yiv1349331506ygrp-vital ul li:last-child {border-right:none !important;}#yiv1349331506

   
Reply | Threaded
Open this post in threaded view
|

Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap

od212
hehe...
ternyata otak saya yang ga nyampe...
 br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 17:09
 Judul: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
   
    Dahsyat rumus nya Guru Mr. Kids nih.....
Thanks Mr. Kids...

      From: "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]>
 To: BeExcel <[hidden email]>
 Sent: Thursday, October 11, 2018 3:14 PM
 Subject: Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Pada ngobrolin apa to...
oh CF untuk id ganjil ya...karena datanya di-merge ?
Coba ya :1. blok semua data (baris dan kolom) [mulai dari record pertama ya] -> beri warna kuning (sebagai genap)2. semua masih terblok, buat CF untuk ganjil saja (gak perlu buat CF yang genap), dengan jenis CF : Use formula, isi dengan formula ini : (misal penentu ganjil genap mulai cells A2, merged)    =isodd(  lookup( 9^9 , $A$2:$A2 ) )
Sesuaikan cell mulai dalam formula dengan cell kolom penentu ganjil genap di record pertama.
Moga-moga hasilnya sesuai kebutuhan.
Regards,Kid






On Thu, Oct 11, 2018 at 1:10 PM Hilman [hidden email] [belajar-excel] <[hidden email]> wrote:

     Sori... formulanya baru ketemu akhirnya ...Alhamdulillah....Setelah dari pagi nyari2.... wkwkwk....

Untuk baris ganjil, pake formula ini...
=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))
untuk baris genap,
=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))


      From: "odong nando [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 12:30 PM
 Subject: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    hai hilman,
bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4, degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan, silakan di coba...  br,

odong nando


      Dari: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: "[hidden email]" <[hidden email]>
 Dikirim: Kamis, 11 Oktober 2018 10:41
 Judul: Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap
 
    Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….


      From: "Hilman [hidden email] [belajar-excel]" <[hidden email]>
 To: "[hidden email]" <[hidden email]>
 Sent: Thursday, October 11, 2018 10:40 AM
 Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]
 
    Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman  

     

     

     
 

     #yiv8888645130 #yiv8888645130 -- #yiv8888645130ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8888645130 #yiv8888645130ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8888645130 #yiv8888645130ygrp-mkp #yiv8888645130hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8888645130 #yiv8888645130ygrp-mkp #yiv8888645130ads {margin-bottom:10px;}#yiv8888645130 #yiv8888645130ygrp-mkp ..yiv8888645130ad {padding:0 0;}#yiv8888645130 #yiv8888645130ygrp-mkp .yiv8888645130ad p {margin:0;}#yiv8888645130 #yiv8888645130ygrp-mkp .yiv8888645130ad a {color:#0000ff;text-decoration:none;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ygrp-lc {font-family:Arial;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ygrp-lc #yiv8888645130hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ygrp-lc .yiv8888645130ad {margin-bottom:10px;padding:0 0;}#yiv8888645130 #yiv8888645130actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8888645130 #yiv8888645130activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8888645130 #yiv8888645130activity span {font-weight:700;}#yiv8888645130 #yiv8888645130activity span:first-child {text-transform:uppercase;}#yiv8888645130 #yiv8888645130activity span a {color:#5085b6;text-decoration:none;}#yiv8888645130 #yiv8888645130activity span span {color:#ff7900;}#yiv8888645130 #yiv8888645130activity span .yiv8888645130underline {text-decoration:underline;}#yiv8888645130 .yiv8888645130attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8888645130 .yiv8888645130attach div a {text-decoration:none;}#yiv8888645130 .yiv8888645130attach img {border:none;padding-right:5px;}#yiv8888645130 .yiv8888645130attach label {display:block;margin-bottom:5px;}#yiv8888645130 .yiv8888645130attach label a {text-decoration:none;}#yiv8888645130 blockquote {margin:0 0 0 4px;}#yiv8888645130 .yiv8888645130bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8888645130 .yiv8888645130bold a {text-decoration:none;}#yiv8888645130 dd.yiv8888645130last p a {font-family:Verdana;font-weight:700;}#yiv8888645130 dd.yiv8888645130last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8888645130 dd.yiv8888645130last p span.yiv8888645130yshortcuts {margin-right:0;}#yiv8888645130 div.yiv8888645130attach-table div div a {text-decoration:none;}#yiv8888645130 div.yiv8888645130attach-table {width:400px;}#yiv8888645130 div.yiv8888645130file-title a, #yiv8888645130 div.yiv8888645130file-title a:active, #yiv8888645130 div.yiv8888645130file-title a:hover, #yiv8888645130 div.yiv8888645130file-title a:visited {text-decoration:none;}#yiv8888645130 div.yiv8888645130photo-title a, #yiv8888645130 div.yiv8888645130photo-title a:active, #yiv8888645130 div.yiv8888645130photo-title a:hover, #yiv8888645130 div.yiv8888645130photo-title a:visited {text-decoration:none;}#yiv8888645130 div#yiv8888645130ygrp-mlmsg #yiv8888645130ygrp-msg p a span.yiv8888645130yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8888645130 .yiv8888645130green {color:#628c2a;}#yiv8888645130 .yiv8888645130MsoNormal {margin:0 0 0 0;}#yiv8888645130 o {font-size:0;}#yiv8888645130 #yiv8888645130photos div {float:left;width:72px;}#yiv8888645130 #yiv8888645130photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8888645130 #yiv8888645130photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8888645130 #yiv8888645130reco-category {font-size:77%;}#yiv8888645130 #yiv8888645130reco-desc {font-size:77%;}#yiv8888645130 .yiv8888645130replbq {margin:4px;}#yiv8888645130 #yiv8888645130ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8888645130 #yiv8888645130ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8888645130 #yiv8888645130ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8888645130 #yiv8888645130ygrp-mlmsg select, #yiv8888645130 input, #yiv8888645130 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8888645130 #yiv8888645130ygrp-mlmsg pre, #yiv8888645130 code {font:115% monospace;}#yiv8888645130 #yiv8888645130ygrp-mlmsg * {line-height:1.22em;}#yiv8888645130 #yiv8888645130ygrp-mlmsg #yiv8888645130logo {padding-bottom:10px;}#yiv8888645130 #yiv8888645130ygrp-msg p a {font-family:Verdana;}#yiv8888645130 #yiv8888645130ygrp-msg p#yiv8888645130attach-count span {color:#1E66AE;font-weight:700;}#yiv8888645130 #yiv8888645130ygrp-reco #yiv8888645130reco-head {color:#ff7900;font-weight:700;}#yiv8888645130 #yiv8888645130ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ov li a {font-size:130%;text-decoration:none;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8888645130 #yiv8888645130ygrp-sponsor #yiv8888645130ov ul {margin:0;padding:0 0 0 8px;}#yiv8888645130 #yiv8888645130ygrp-text {font-family:Georgia;}#yiv8888645130 #yiv8888645130ygrp-text p {margin:0 0 1em 0;}#yiv8888645130 #yiv8888645130ygrp-text tt {font-size:120%;}#yiv8888645130 #yiv8888645130ygrp-vital ul li:last-child {border-right:none !important;}#yiv8888645130

   
Reply | Threaded
Open this post in threaded view
|

RE: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]

M.Ade Alfarid
Mungkin pilihan yang lain,



ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Thursday, October 11, 2018 5:35 PM
*To:* [hidden email]
*Subject:* Bls: Bls: [belajar-excel] Conditional Formating Untuk Baris
Ganjil dan Baris Genap





hehe...
ternyata otak saya yang ga nyampe...

[image: Image removed by sender. *#:-S whew!][image: Image removed by
sender. *#:-S whew!]



br,

odong nando


------------------------------

*Dari:* "Hilman [hidden email] [belajar-excel]" <
[hidden email]>
*Kepada:* "[hidden email]" <[hidden email]>
*Dikirim:* Kamis, 11 Oktober 2018 17:09
*Judul:* Re: Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil
dan Baris Genap





Dahsyat rumus nya Guru Mr. Kids nih.....



Thanks Mr. Kids...


------------------------------

*From:* "'Mr. Kid' [hidden email] [belajar-excel]" <
[hidden email]>
*To:* BeExcel <[hidden email]>
*Sent:* Thursday, October 11, 2018 3:14 PM
*Subject:* Re: Bls: [belajar-excel] Conditional Formating Untuk Baris
Ganjil dan Baris Genap





Pada ngobrolin apa to...



oh CF untuk id ganjil ya...

karena datanya di-merge ?



Coba ya :

1. blok semua data (baris dan kolom) [mulai dari record pertama ya] -> beri
warna kuning (sebagai genap)

2. semua masih terblok, buat CF untuk ganjil saja (gak perlu buat CF yang
genap), dengan jenis CF : Use formula, isi dengan formula ini : (misal
penentu ganjil genap mulai cells A2, merged)

    =isodd(  lookup( 9^9 , $A$2:$A2 ) )



Sesuaikan cell mulai dalam formula dengan cell kolom penentu ganjil genap
di record pertama.

Moga-moga hasilnya sesuai kebutuhan.



Regards,

Kid















On Thu, Oct 11, 2018 at 1:10 PM Hilman [hidden email]
[belajar-excel] <[hidden email]> wrote:



Sori... formulanya baru ketemu akhirnya ...

Alhamdulillah....

Setelah dari pagi nyari2.... wkwkwk....





Untuk baris ganjil, pake formula ini...



=ISODD(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))



untuk baris genap,



=ISEVEN(IF(SUM($A$7:$A7)=1,1,COMBIN(COUNTA($A$7:$A7)+1,2)-COMBIN(COUNTA($A$7:$A7),2)))




------------------------------

*From:* "odong nando [hidden email] [belajar-excel]" <
[hidden email]>
*To:* "[hidden email]" <[hidden email]
<belajar-excel@yahoogroups..com>>
*Sent:* Thursday, October 11, 2018 12:30 PM
*Subject:* Bls: [belajar-excel] Conditional Formating Untuk Baris Ganjil
dan Baris Genap





hai hilman,



bisa banget, tinggal sediakan 2 kolom bantu, kolom refresi 1,3,5 & 2,4,
degan bantuan MATCH, tinggal di pasang k bagian yang akan di CF kan,
silakan di coba... [image: Image removed by sender. *:) senang][image:
Image removed by sender. *:) senang]



br,

odong nando


------------------------------

*Dari:* "Hilman [hidden email] [belajar-excel]" <
[hidden email]>
*Kepada:* "[hidden email]" <[hidden email]>
*Dikirim:* Kamis, 11 Oktober 2018 10:41
*Judul:* Re: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap





Maksudnya...



Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya
akan kuning, sedangkan row 2,4 warnanya hijau..

Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya
akan tetap kuning atau tetap hijau….




------------------------------

*From:* "Hilman [hidden email] [belajar-excel]" <
[hidden email]>
*To:* "[hidden email]" <[hidden email]>
*Sent:* Thursday, October 11, 2018 10:40 AM
*Subject:* [belajar-excel] Conditional Formating Untuk Baris Ganjil dan
Baris Genap [1 Attachment]





Dear All



Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya
akan kuning, sedangkan row 4,5 warnanya hijau..

Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya
akan tetap kuning atau tetap hijau….



Makasih yaaa....



Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan
ternyata jadi gak tajam lagi...

hehehehe....



Salam

Hilman













~WRD000.jpg (1K) Download Attachment
image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
reade-Conditional Formating Untuk Baris ganjil dan genap.xlsx (14K) Download Attachment