Terimakasih mas wendi, tetapi yang saya maksud pengkondisian kalimat teks atau
hurufnya, mas..!
Pada Selasa, 6 Oktober 2015 21:38, "wendi surdinal [email protected]
[belajar-excel]" <[email protected]> menulis:
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
#yiv7203465449 #yiv7203465449 -- #yiv7203465449ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7203465449
#yiv7203465449ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7203465449
#yiv7203465449ygrp-mkp #yiv7203465449hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7203465449 #yiv7203465449ygrp-mkp #yiv7203465449ads
{margin-bottom:10px;}#yiv7203465449 #yiv7203465449ygrp-mkp .yiv7203465449ad
{padding:0 0;}#yiv7203465449 #yiv7203465449ygrp-mkp .yiv7203465449ad p
{margin:0;}#yiv7203465449 #yiv7203465449ygrp-mkp .yiv7203465449ad a
{color:#0000ff;text-decoration:none;}#yiv7203465449 #yiv7203465449ygrp-sponsor
#yiv7203465449ygrp-lc {font-family:Arial;}#yiv7203465449
#yiv7203465449ygrp-sponsor #yiv7203465449ygrp-lc #yiv7203465449hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7203465449
#yiv7203465449ygrp-sponsor #yiv7203465449ygrp-lc .yiv7203465449ad
{margin-bottom:10px;padding:0 0;}#yiv7203465449 #yiv7203465449actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7203465449
#yiv7203465449activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7203465449
#yiv7203465449activity span {font-weight:700;}#yiv7203465449
#yiv7203465449activity span:first-child
{text-transform:uppercase;}#yiv7203465449 #yiv7203465449activity span a
{color:#5085b6;text-decoration:none;}#yiv7203465449 #yiv7203465449activity span
span {color:#ff7900;}#yiv7203465449 #yiv7203465449activity span
.yiv7203465449underline {text-decoration:underline;}#yiv7203465449
.yiv7203465449attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7203465449 .yiv7203465449attach div a
{text-decoration:none;}#yiv7203465449 .yiv7203465449attach img
{border:none;padding-right:5px;}#yiv7203465449 .yiv7203465449attach label
{display:block;margin-bottom:5px;}#yiv7203465449 .yiv7203465449attach label a
{text-decoration:none;}#yiv7203465449 blockquote {margin:0 0 0
4px;}#yiv7203465449 .yiv7203465449bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7203465449
.yiv7203465449bold a {text-decoration:none;}#yiv7203465449 dd.yiv7203465449last
p a {font-family:Verdana;font-weight:700;}#yiv7203465449 dd.yiv7203465449last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7203465449
dd.yiv7203465449last p span.yiv7203465449yshortcuts
{margin-right:0;}#yiv7203465449 div.yiv7203465449attach-table div div a
{text-decoration:none;}#yiv7203465449 div.yiv7203465449attach-table
{width:400px;}#yiv7203465449 div.yiv7203465449file-title a, #yiv7203465449
div.yiv7203465449file-title a:active, #yiv7203465449
div.yiv7203465449file-title a:hover, #yiv7203465449 div.yiv7203465449file-title
a:visited {text-decoration:none;}#yiv7203465449 div.yiv7203465449photo-title a,
#yiv7203465449 div.yiv7203465449photo-title a:active, #yiv7203465449
div.yiv7203465449photo-title a:hover, #yiv7203465449
div.yiv7203465449photo-title a:visited {text-decoration:none;}#yiv7203465449
div#yiv7203465449ygrp-mlmsg #yiv7203465449ygrp-msg p a
span.yiv7203465449yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7203465449
.yiv7203465449green {color:#628c2a;}#yiv7203465449 .yiv7203465449MsoNormal
{margin:0 0 0 0;}#yiv7203465449 o {font-size:0;}#yiv7203465449
#yiv7203465449photos div {float:left;width:72px;}#yiv7203465449
#yiv7203465449photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7203465449
#yiv7203465449photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7203465449
#yiv7203465449reco-category {font-size:77%;}#yiv7203465449
#yiv7203465449reco-desc {font-size:77%;}#yiv7203465449 .yiv7203465449replbq
{margin:4px;}#yiv7203465449 #yiv7203465449ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7203465449 #yiv7203465449ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7203465449
#yiv7203465449ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7203465449
#yiv7203465449ygrp-mlmsg select, #yiv7203465449 input, #yiv7203465449 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7203465449
#yiv7203465449ygrp-mlmsg pre, #yiv7203465449 code {font:115%
monospace;}#yiv7203465449 #yiv7203465449ygrp-mlmsg *
{line-height:1.22em;}#yiv7203465449 #yiv7203465449ygrp-mlmsg #yiv7203465449logo
{padding-bottom:10px;}#yiv7203465449 #yiv7203465449ygrp-msg p a
{font-family:Verdana;}#yiv7203465449 #yiv7203465449ygrp-msg
p#yiv7203465449attach-count span {color:#1E66AE;font-weight:700;}#yiv7203465449
#yiv7203465449ygrp-reco #yiv7203465449reco-head
{color:#ff7900;font-weight:700;}#yiv7203465449 #yiv7203465449ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7203465449 #yiv7203465449ygrp-sponsor
#yiv7203465449ov li a {font-size:130%;text-decoration:none;}#yiv7203465449
#yiv7203465449ygrp-sponsor #yiv7203465449ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7203465449
#yiv7203465449ygrp-sponsor #yiv7203465449ov ul {margin:0;padding:0 0 0
8px;}#yiv7203465449 #yiv7203465449ygrp-text
{font-family:Georgia;}#yiv7203465449 #yiv7203465449ygrp-text p {margin:0 0 1em
0;}#yiv7203465449 #yiv7203465449ygrp-text tt {font-size:120%;}#yiv7203465449
#yiv7203465449ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7203465449
