Dear Pak Ghozi,
Terima kasih banyak ya Pak atas bantuannya 🙏🙏🙏
Sent from Yahoo Mail on Android
On Tue, Feb 5, 2019 at 4:53 PM, ghozi alkatiri [email protected]
[belajar-excel]<[email protected]> wrote:
blok seluruh tabel yang ingin ditarget mulai dari A3
tulis formula di conditional formating
=IF(A3<TODAY(),TRUE)
wassalam
Ghozi Alkatiri
Pada Selasa, 5 Februari 2019 15.09.11 WIB, ivan budiman
[email protected] [belajar-excel] <[email protected]> menulis:
Dear Rekan2 BeExcel,
Mohon bantuannya, sudah beberapa kali saya coba, namun tidak berhasil.
Saya ingin melakukan conditional formating (highlight) untuk tanggal yang sudah
lewat dari TODAY. Saya sudah coba, namun yang masih upcoming juga terhighlight.
Apakah ada teman2 beExcel yang bisa bantu?
Terlampir filenya.
Terima kasih banyak atas bantuannya.
Regards,
M I B
- thankfulness - #yiv9881941904 #yiv9881941904 -- #yiv9881941904ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv9881941904 #yiv9881941904ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9881941904 #yiv9881941904ygrp-mkp #yiv9881941904hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9881941904 #yiv9881941904ygrp-mkp #yiv9881941904ads
{margin-bottom:10px;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad
{padding:0 0;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad p
{margin:0;}#yiv9881941904 #yiv9881941904ygrp-mkp .yiv9881941904ad a
{color:#0000ff;text-decoration:none;}#yiv9881941904 #yiv9881941904ygrp-sponsor
#yiv9881941904ygrp-lc {font-family:Arial;}#yiv9881941904
#yiv9881941904ygrp-sponsor #yiv9881941904ygrp-lc #yiv9881941904hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9881941904
#yiv9881941904ygrp-sponsor #yiv9881941904ygrp-lc .yiv9881941904ad
{margin-bottom:10px;padding:0 0;}#yiv9881941904 #yiv9881941904actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9881941904
#yiv9881941904activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9881941904
#yiv9881941904activity span {font-weight:700;}#yiv9881941904
#yiv9881941904activity span:first-child
{text-transform:uppercase;}#yiv9881941904 #yiv9881941904activity span a
{color:#5085b6;text-decoration:none;}#yiv9881941904 #yiv9881941904activity span
span {color:#ff7900;}#yiv9881941904 #yiv9881941904activity span
.yiv9881941904underline {text-decoration:underline;}#yiv9881941904
.yiv9881941904attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9881941904 .yiv9881941904attach div a
{text-decoration:none;}#yiv9881941904 .yiv9881941904attach img
{border:none;padding-right:5px;}#yiv9881941904 .yiv9881941904attach label
{display:block;margin-bottom:5px;}#yiv9881941904 .yiv9881941904attach label a
{text-decoration:none;}#yiv9881941904 blockquote {margin:0 0 0
4px;}#yiv9881941904 .yiv9881941904bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9881941904
.yiv9881941904bold a {text-decoration:none;}#yiv9881941904 dd.yiv9881941904last
p a {font-family:Verdana;font-weight:700;}#yiv9881941904 dd.yiv9881941904last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9881941904
dd.yiv9881941904last p span.yiv9881941904yshortcuts
{margin-right:0;}#yiv9881941904 div.yiv9881941904attach-table div div a
{text-decoration:none;}#yiv9881941904 div..yiv9881941904attach-table
{width:400px;}#yiv9881941904 div.yiv9881941904file-title a, #yiv9881941904
div.yiv9881941904file-title a:active, #yiv9881941904
div.yiv9881941904file-title a:hover, #yiv9881941904 div.yiv9881941904file-title
a:visited {text-decoration:none;}#yiv9881941904 div.yiv9881941904photo-title a,
#yiv9881941904 div.yiv9881941904photo-title a:active, #yiv9881941904
div.yiv9881941904photo-title a:hover, #yiv9881941904
div.yiv9881941904photo-title a:visited {text-decoration:none;}#yiv9881941904
div#yiv9881941904ygrp-mlmsg #yiv9881941904ygrp-msg p a
span.yiv9881941904yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9881941904
.yiv9881941904green {color:#628c2a;}#yiv9881941904 .yiv9881941904MsoNormal
{margin:0 0 0 0;}#yiv9881941904 o {font-size:0;}#yiv9881941904
#yiv9881941904photos div {float:left;width:72px;}#yiv9881941904
#yiv9881941904photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9881941904
#yiv9881941904photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9881941904
#yiv9881941904reco-category {font-size:77%;}#yiv9881941904
#yiv9881941904reco-desc {font-size:77%;}#yiv9881941904 .yiv9881941904replbq
{margin:4px;}#yiv9881941904 #yiv9881941904ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9881941904 #yiv9881941904ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9881941904
#yiv9881941904ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9881941904
#yiv9881941904ygrp-mlmsg select, #yiv9881941904 input, #yiv9881941904 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9881941904
#yiv9881941904ygrp-mlmsg pre, #yiv9881941904 code {font:115%
monospace;}#yiv9881941904 #yiv9881941904ygrp-mlmsg *
{line-height:1.22em;}#yiv9881941904 #yiv9881941904ygrp-mlmsg #yiv9881941904logo
{padding-bottom:10px;}#yiv9881941904 #yiv9881941904ygrp-msg p a
{font-family:Verdana;}#yiv9881941904 #yiv9881941904ygrp-msg
p#yiv9881941904attach-count span {color:#1E66AE;font-weight:700;}#yiv9881941904
#yiv9881941904ygrp-reco #yiv9881941904reco-head
{color:#ff7900;font-weight:700;}#yiv9881941904 #yiv9881941904ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9881941904 #yiv9881941904ygrp-sponsor
#yiv9881941904ov li a {font-size:130%;text-decoration:none;}#yiv9881941904
#yiv9881941904ygrp-sponsor #yiv9881941904ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9881941904
#yiv9881941904ygrp-sponsor #yiv9881941904ov ul {margin:0;padding:0 0 0
8px;}#yiv9881941904 #yiv9881941904ygrp-text
{font-family:Georgia;}#yiv9881941904 #yiv9881941904ygrp-text p {margin:0 0 1em
0;}#yiv9881941904 #yiv9881941904ygrp-text tt {font-size:120%;}#yiv9881941904
#yiv9881941904ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9881941904
