maksud saya G10>F10ini file nya saya lampirkanmohon bantuannya mister terima kasih
On Monday, June 8, 2015 8:59 AM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Dari gambar tersebut, yang Anda buat adalah :
> pada range G10 akan diberi warna kuning dengan font bold jika nilai di range
> F10 lebih dari nilai di range F10
> hal ini diterapkan pada seluruh range di G10:G358
> karena dalam formula kondisi tidak ada $, maka di G321 akan berlaku kondisi
> jika nilai range F321 lebih dari nilai di range F321
Coba Anda ikuti lagi langkahnya dengan seksama, dan perhatikan dengan benar
ranges yang menjadi rujukan bunyi formulanya.
Bagaimana logikanya nilai F10>F10 ? Apakah mungkin ?
2015-06-08 11:19 GMT+10:00 [email protected] [belajar-excel]
<[email protected]>:
saya sudah coba seperti instruksi mister tapi hasilnya seperti ini (gambar
terlampir). belum bisa
#yiv4701936732 #yiv4701936732 -- #yiv4701936732ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4701936732
#yiv4701936732ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4701936732
#yiv4701936732ygrp-mkp #yiv4701936732hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4701936732 #yiv4701936732ygrp-mkp #yiv4701936732ads
{margin-bottom:10px;}#yiv4701936732 #yiv4701936732ygrp-mkp .yiv4701936732ad
{padding:0 0;}#yiv4701936732 #yiv4701936732ygrp-mkp .yiv4701936732ad p
{margin:0;}#yiv4701936732 #yiv4701936732ygrp-mkp .yiv4701936732ad a
{color:#0000ff;text-decoration:none;}#yiv4701936732 #yiv4701936732ygrp-sponsor
#yiv4701936732ygrp-lc {font-family:Arial;}#yiv4701936732
#yiv4701936732ygrp-sponsor #yiv4701936732ygrp-lc #yiv4701936732hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4701936732
#yiv4701936732ygrp-sponsor #yiv4701936732ygrp-lc .yiv4701936732ad
{margin-bottom:10px;padding:0 0;}#yiv4701936732 #yiv4701936732actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4701936732
#yiv4701936732activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4701936732
#yiv4701936732activity span {font-weight:700;}#yiv4701936732
#yiv4701936732activity span:first-child
{text-transform:uppercase;}#yiv4701936732 #yiv4701936732activity span a
{color:#5085b6;text-decoration:none;}#yiv4701936732 #yiv4701936732activity span
span {color:#ff7900;}#yiv4701936732 #yiv4701936732activity span
.yiv4701936732underline {text-decoration:underline;}#yiv4701936732
.yiv4701936732attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4701936732 .yiv4701936732attach div a
{text-decoration:none;}#yiv4701936732 .yiv4701936732attach img
{border:none;padding-right:5px;}#yiv4701936732 .yiv4701936732attach label
{display:block;margin-bottom:5px;}#yiv4701936732 .yiv4701936732attach label a
{text-decoration:none;}#yiv4701936732 blockquote {margin:0 0 0
4px;}#yiv4701936732 .yiv4701936732bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4701936732
.yiv4701936732bold a {text-decoration:none;}#yiv4701936732 dd.yiv4701936732last
p a {font-family:Verdana;font-weight:700;}#yiv4701936732 dd.yiv4701936732last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4701936732
dd.yiv4701936732last p span.yiv4701936732yshortcuts
{margin-right:0;}#yiv4701936732 div.yiv4701936732attach-table div div a
{text-decoration:none;}#yiv4701936732 div.yiv4701936732attach-table
{width:400px;}#yiv4701936732 div.yiv4701936732file-title a, #yiv4701936732
div.yiv4701936732file-title a:active, #yiv4701936732
div.yiv4701936732file-title a:hover, #yiv4701936732 div.yiv4701936732file-title
a:visited {text-decoration:none;}#yiv4701936732 div.yiv4701936732photo-title a,
#yiv4701936732 div.yiv4701936732photo-title a:active, #yiv4701936732
div.yiv4701936732photo-title a:hover, #yiv4701936732
div.yiv4701936732photo-title a:visited {text-decoration:none;}#yiv4701936732
div#yiv4701936732ygrp-mlmsg #yiv4701936732ygrp-msg p a
span.yiv4701936732yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4701936732
.yiv4701936732green {color:#628c2a;}#yiv4701936732 .yiv4701936732MsoNormal
{margin:0 0 0 0;}#yiv4701936732 o {font-size:0;}#yiv4701936732
#yiv4701936732photos div {float:left;width:72px;}#yiv4701936732
#yiv4701936732photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4701936732
#yiv4701936732photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4701936732
#yiv4701936732reco-category {font-size:77%;}#yiv4701936732
#yiv4701936732reco-desc {font-size:77%;}#yiv4701936732 .yiv4701936732replbq
{margin:4px;}#yiv4701936732 #yiv4701936732ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4701936732 #yiv4701936732ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4701936732
#yiv4701936732ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4701936732
#yiv4701936732ygrp-mlmsg select, #yiv4701936732 input, #yiv4701936732 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4701936732
#yiv4701936732ygrp-mlmsg pre, #yiv4701936732 code {font:115%
monospace;}#yiv4701936732 #yiv4701936732ygrp-mlmsg *
{line-height:1.22em;}#yiv4701936732 #yiv4701936732ygrp-mlmsg #yiv4701936732logo
{padding-bottom:10px;}#yiv4701936732 #yiv4701936732ygrp-msg p a
{font-family:Verdana;}#yiv4701936732 #yiv4701936732ygrp-msg
p#yiv4701936732attach-count span {color:#1E66AE;font-weight:700;}#yiv4701936732
#yiv4701936732ygrp-reco #yiv4701936732reco-head
{color:#ff7900;font-weight:700;}#yiv4701936732 #yiv4701936732ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4701936732 #yiv4701936732ygrp-sponsor
#yiv4701936732ov li a {font-size:130%;text-decoration:none;}#yiv4701936732
#yiv4701936732ygrp-sponsor #yiv4701936732ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4701936732
#yiv4701936732ygrp-sponsor #yiv4701936732ov ul {margin:0;padding:0 0 0
8px;}#yiv4701936732 #yiv4701936732ygrp-text
{font-family:Georgia;}#yiv4701936732 #yiv4701936732ygrp-text p {margin:0 0 1em
0;}#yiv4701936732 #yiv4701936732ygrp-text tt {font-size:120%;}#yiv4701936732
#yiv4701936732ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4701936732
Conditional Format.xlsx
Description: MS-Excel 2007 spreadsheet
