coba dengan versi ini pak huznul faizin
Pada Selasa, 6 Oktober 2015 17:12, "Husnul Faizin [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamu'alaikum.
Yth. Master Be-Xcel
Mohon Bantuan para master Be-xcel pemberian warna font dengan CF atau script
macro:
Solusi yang di inginkan:
1) Kalimat Nilai " Tujuh Puluh " atau sesuai KKM di cell "B5" dan yang lebih
besar dari nilai KKM akan terkondisi berwarna "Biru"
2) Kalimat Nilai yang lebih rendah dari "Tujuh Puluh" misalkan kalimat yang
dimulai dari kata "Enam puluh sembilan" atau yang
lebih rendah; akan terkondisi berwarna "Merah".
Berikut lampiran filenya
Terimakasih sebelumnya!
Salam
HF #yiv4147164219 #yiv4147164219 -- #yiv4147164219ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4147164219
#yiv4147164219ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4147164219
#yiv4147164219ygrp-mkp #yiv4147164219hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4147164219 #yiv4147164219ygrp-mkp #yiv4147164219ads
{margin-bottom:10px;}#yiv4147164219 #yiv4147164219ygrp-mkp .yiv4147164219ad
{padding:0 0;}#yiv4147164219 #yiv4147164219ygrp-mkp .yiv4147164219ad p
{margin:0;}#yiv4147164219 #yiv4147164219ygrp-mkp .yiv4147164219ad a
{color:#0000ff;text-decoration:none;}#yiv4147164219 #yiv4147164219ygrp-sponsor
#yiv4147164219ygrp-lc {font-family:Arial;}#yiv4147164219
#yiv4147164219ygrp-sponsor #yiv4147164219ygrp-lc #yiv4147164219hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4147164219
#yiv4147164219ygrp-sponsor #yiv4147164219ygrp-lc .yiv4147164219ad
{margin-bottom:10px;padding:0 0;}#yiv4147164219 #yiv4147164219actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4147164219
#yiv4147164219activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4147164219
#yiv4147164219activity span {font-weight:700;}#yiv4147164219
#yiv4147164219activity span:first-child
{text-transform:uppercase;}#yiv4147164219 #yiv4147164219activity span a
{color:#5085b6;text-decoration:none;}#yiv4147164219 #yiv4147164219activity span
span {color:#ff7900;}#yiv4147164219 #yiv4147164219activity span
.yiv4147164219underline {text-decoration:underline;}#yiv4147164219
.yiv4147164219attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4147164219 .yiv4147164219attach div a
{text-decoration:none;}#yiv4147164219 .yiv4147164219attach img
{border:none;padding-right:5px;}#yiv4147164219 .yiv4147164219attach label
{display:block;margin-bottom:5px;}#yiv4147164219 .yiv4147164219attach label a
{text-decoration:none;}#yiv4147164219 blockquote {margin:0 0 0
4px;}#yiv4147164219 .yiv4147164219bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4147164219
.yiv4147164219bold a {text-decoration:none;}#yiv4147164219 dd.yiv4147164219last
p a {font-family:Verdana;font-weight:700;}#yiv4147164219 dd.yiv4147164219last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4147164219
dd.yiv4147164219last p span.yiv4147164219yshortcuts
{margin-right:0;}#yiv4147164219 div.yiv4147164219attach-table div div a
{text-decoration:none;}#yiv4147164219 div.yiv4147164219attach-table
{width:400px;}#yiv4147164219 div.yiv4147164219file-title a, #yiv4147164219
div.yiv4147164219file-title a:active, #yiv4147164219
div.yiv4147164219file-title a:hover, #yiv4147164219 div.yiv4147164219file-title
a:visited {text-decoration:none;}#yiv4147164219 div.yiv4147164219photo-title a,
#yiv4147164219 div.yiv4147164219photo-title a:active, #yiv4147164219
div.yiv4147164219photo-title a:hover, #yiv4147164219
div.yiv4147164219photo-title a:visited {text-decoration:none;}#yiv4147164219
div#yiv4147164219ygrp-mlmsg #yiv4147164219ygrp-msg p a
span.yiv4147164219yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4147164219
.yiv4147164219green {color:#628c2a;}#yiv4147164219 .yiv4147164219MsoNormal
{margin:0 0 0 0;}#yiv4147164219 o {font-size:0;}#yiv4147164219
#yiv4147164219photos div {float:left;width:72px;}#yiv4147164219
#yiv4147164219photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4147164219
#yiv4147164219photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4147164219
#yiv4147164219reco-category {font-size:77%;}#yiv4147164219
#yiv4147164219reco-desc {font-size:77%;}#yiv4147164219 .yiv4147164219replbq
{margin:4px;}#yiv4147164219 #yiv4147164219ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4147164219 #yiv4147164219ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4147164219
#yiv4147164219ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4147164219
#yiv4147164219ygrp-mlmsg select, #yiv4147164219 input, #yiv4147164219 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4147164219
#yiv4147164219ygrp-mlmsg pre, #yiv4147164219 code {font:115%
monospace;}#yiv4147164219 #yiv4147164219ygrp-mlmsg *
{line-height:1.22em;}#yiv4147164219 #yiv4147164219ygrp-mlmsg #yiv4147164219logo
{padding-bottom:10px;}#yiv4147164219 #yiv4147164219ygrp-msg p a
{font-family:Verdana;}#yiv4147164219 #yiv4147164219ygrp-msg
p#yiv4147164219attach-count span {color:#1E66AE;font-weight:700;}#yiv4147164219
#yiv4147164219ygrp-reco #yiv4147164219reco-head
{color:#ff7900;font-weight:700;}#yiv4147164219 #yiv4147164219ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4147164219 #yiv4147164219ygrp-sponsor
#yiv4147164219ov li a {font-size:130%;text-decoration:none;}#yiv4147164219
#yiv4147164219ygrp-sponsor #yiv4147164219ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4147164219
#yiv4147164219ygrp-sponsor #yiv4147164219ov ul {margin:0;padding:0 0 0
8px;}#yiv4147164219 #yiv4147164219ygrp-text
{font-family:Georgia;}#yiv4147164219 #yiv4147164219ygrp-text p {margin:0 0 1em
0;}#yiv4147164219 #yiv4147164219ygrp-text tt {font-size:120%;}#yiv4147164219
#yiv4147164219ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4147164219
Help_CF.xlsx
Description: MS-Excel 2007 spreadsheet
