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
Description: MS-Excel 2007 spreadsheet
