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
ivanst...@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> 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 - #yiv9554728456 #yiv9554728456 -- #yiv9554728456ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv9554728456 #yiv9554728456ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9554728456 #yiv9554728456ygrp-mkp #yiv9554728456hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9554728456 #yiv9554728456ygrp-mkp #yiv9554728456ads
{margin-bottom:10px;}#yiv9554728456 #yiv9554728456ygrp-mkp .yiv9554728456ad
{padding:0 0;}#yiv9554728456 #yiv9554728456ygrp-mkp .yiv9554728456ad p
{margin:0;}#yiv9554728456 #yiv9554728456ygrp-mkp ..yiv9554728456ad a
{color:#0000ff;text-decoration:none;}#yiv9554728456 #yiv9554728456ygrp-sponsor
#yiv9554728456ygrp-lc {font-family:Arial;}#yiv9554728456
#yiv9554728456ygrp-sponsor #yiv9554728456ygrp-lc #yiv9554728456hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9554728456
#yiv9554728456ygrp-sponsor #yiv9554728456ygrp-lc .yiv9554728456ad
{margin-bottom:10px;padding:0 0;}#yiv9554728456 #yiv9554728456actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9554728456
#yiv9554728456activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9554728456
#yiv9554728456activity span {font-weight:700;}#yiv9554728456
#yiv9554728456activity span:first-child
{text-transform:uppercase;}#yiv9554728456 #yiv9554728456activity span a
{color:#5085b6;text-decoration:none;}#yiv9554728456 #yiv9554728456activity span
span {color:#ff7900;}#yiv9554728456 #yiv9554728456activity span
.yiv9554728456underline {text-decoration:underline;}#yiv9554728456
.yiv9554728456attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9554728456 .yiv9554728456attach div a
{text-decoration:none;}#yiv9554728456 ..yiv9554728456attach img
{border:none;padding-right:5px;}#yiv9554728456 .yiv9554728456attach label
{display:block;margin-bottom:5px;}#yiv9554728456 .yiv9554728456attach label a
{text-decoration:none;}#yiv9554728456 blockquote {margin:0 0 0
4px;}#yiv9554728456 .yiv9554728456bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9554728456
.yiv9554728456bold a {text-decoration:none;}#yiv9554728456 dd.yiv9554728456last
p a {font-family:Verdana;font-weight:700;}#yiv9554728456 dd.yiv9554728456last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9554728456
dd.yiv9554728456last p span.yiv9554728456yshortcuts
{margin-right:0;}#yiv9554728456 div.yiv9554728456attach-table div div a
{text-decoration:none;}#yiv9554728456 div.yiv9554728456attach-table
{width:400px;}#yiv9554728456 div.yiv9554728456file-title a, #yiv9554728456
div.yiv9554728456file-title a:active, #yiv9554728456
div.yiv9554728456file-title a:hover, #yiv9554728456 div.yiv9554728456file-title
a:visited {text-decoration:none;}#yiv9554728456 div.yiv9554728456photo-title a,
#yiv9554728456 div.yiv9554728456photo-title a:active, #yiv9554728456
div.yiv9554728456photo-title a:hover, #yiv9554728456
div.yiv9554728456photo-title a:visited {text-decoration:none;}#yiv9554728456
div#yiv9554728456ygrp-mlmsg #yiv9554728456ygrp-msg p a
span.yiv9554728456yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9554728456
.yiv9554728456green {color:#628c2a;}#yiv9554728456 .yiv9554728456MsoNormal
{margin:0 0 0 0;}#yiv9554728456 o {font-size:0;}#yiv9554728456
#yiv9554728456photos div {float:left;width:72px;}#yiv9554728456
#yiv9554728456photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9554728456
#yiv9554728456photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9554728456
#yiv9554728456reco-category {font-size:77%;}#yiv9554728456
#yiv9554728456reco-desc {font-size:77%;}#yiv9554728456 .yiv9554728456replbq
{margin:4px;}#yiv9554728456 #yiv9554728456ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9554728456 #yiv9554728456ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9554728456
#yiv9554728456ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9554728456
#yiv9554728456ygrp-mlmsg select, #yiv9554728456 input, #yiv9554728456 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9554728456
#yiv9554728456ygrp-mlmsg pre, #yiv9554728456 code {font:115%
monospace;}#yiv9554728456 #yiv9554728456ygrp-mlmsg *
{line-height:1.22em;}#yiv9554728456 #yiv9554728456ygrp-mlmsg #yiv9554728456logo
{padding-bottom:10px;}#yiv9554728456 #yiv9554728456ygrp-msg p a
{font-family:Verdana;}#yiv9554728456 #yiv9554728456ygrp-msg
p#yiv9554728456attach-count span {color:#1E66AE;font-weight:700;}#yiv9554728456
#yiv9554728456ygrp-reco #yiv9554728456reco-head
{color:#ff7900;font-weight:700;}#yiv9554728456 #yiv9554728456ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9554728456 #yiv9554728456ygrp-sponsor
#yiv9554728456ov li a {font-size:130%;text-decoration:none;}#yiv9554728456
#yiv9554728456ygrp-sponsor #yiv9554728456ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9554728456
#yiv9554728456ygrp-sponsor #yiv9554728456ov ul {margin:0;padding:0 0 0
8px;}#yiv9554728456 #yiv9554728456ygrp-text
{font-family:Georgia;}#yiv9554728456 #yiv9554728456ygrp-text p {margin:0 0 1em
0;}#yiv9554728456 #yiv9554728456ygrp-text tt {font-size:120%;}#yiv9554728456
#yiv9554728456ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9554728456
ghozi05022019Conditional Formating.xlsx
Description: MS-Excel 2007 spreadsheet
