Hai Nurani,
Perubahan warna pada sel yang ada dalam Sheet (jika selnya diedit) pernah
dibuat oleh almh CTV.File terlampir.
Salam,HK
NB : Jika yang diinginkan adalah perubahan warna pada Sheet Tab maka perlu
dipikirkan apakah Sheet yang pernah diakses pasti telah berubah/diupdate
datanya (copy paste data).
From: "[email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Sunday, 31 May 2015, 12:12
Subject: [belajar-excel] keterangan sheet yang sudah di isi [1 Attachment]
Hello Mr.
Terima kasih sudah banyak bantu saya. pengetahuan excel saya semakin bertambah.
Kali ini saya mau tanya.Saya punya suatu workbook yang isinya 50sheet.saya
ingin ketika saya mengganti data pada sheet-sheet tsb. terjadi perubahan warna
atau keterangan lain.yang menandakan bahwa sheet tsb sudah saya update datanya
(copy paste data).sehingga tidak ada yang tertinggal (belum di paste data
terbaru atau di paste dua kali. bagaimana caranya mister.butuh pencerahan.
Terima kasihWassalamNurani #yiv6948892724 #yiv6948892724 --
#yiv6948892724ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv6948892724 #yiv6948892724ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv6948892724 #yiv6948892724ygrp-mkp #yiv6948892724hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6948892724 #yiv6948892724ygrp-mkp #yiv6948892724ads
{margin-bottom:10px;}#yiv6948892724 #yiv6948892724ygrp-mkp .yiv6948892724ad
{padding:0 0;}#yiv6948892724 #yiv6948892724ygrp-mkp .yiv6948892724ad p
{margin:0;}#yiv6948892724 #yiv6948892724ygrp-mkp .yiv6948892724ad a
{color:#0000ff;text-decoration:none;}#yiv6948892724 #yiv6948892724ygrp-sponsor
#yiv6948892724ygrp-lc {font-family:Arial;}#yiv6948892724
#yiv6948892724ygrp-sponsor #yiv6948892724ygrp-lc #yiv6948892724hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6948892724
#yiv6948892724ygrp-sponsor #yiv6948892724ygrp-lc .yiv6948892724ad
{margin-bottom:10px;padding:0 0;}#yiv6948892724 #yiv6948892724actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6948892724
#yiv6948892724activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6948892724
#yiv6948892724activity span {font-weight:700;}#yiv6948892724
#yiv6948892724activity span:first-child
{text-transform:uppercase;}#yiv6948892724 #yiv6948892724activity span a
{color:#5085b6;text-decoration:none;}#yiv6948892724 #yiv6948892724activity span
span {color:#ff7900;}#yiv6948892724 #yiv6948892724activity span
.yiv6948892724underline {text-decoration:underline;}#yiv6948892724
.yiv6948892724attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6948892724 .yiv6948892724attach div a
{text-decoration:none;}#yiv6948892724 .yiv6948892724attach img
{border:none;padding-right:5px;}#yiv6948892724 .yiv6948892724attach label
{display:block;margin-bottom:5px;}#yiv6948892724 .yiv6948892724attach label a
{text-decoration:none;}#yiv6948892724 blockquote {margin:0 0 0
4px;}#yiv6948892724 .yiv6948892724bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6948892724
.yiv6948892724bold a {text-decoration:none;}#yiv6948892724 dd.yiv6948892724last
p a {font-family:Verdana;font-weight:700;}#yiv6948892724 dd.yiv6948892724last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6948892724
dd.yiv6948892724last p span.yiv6948892724yshortcuts
{margin-right:0;}#yiv6948892724 div.yiv6948892724attach-table div div a
{text-decoration:none;}#yiv6948892724 div.yiv6948892724attach-table
{width:400px;}#yiv6948892724 div.yiv6948892724file-title a, #yiv6948892724
div.yiv6948892724file-title a:active, #yiv6948892724
div.yiv6948892724file-title a:hover, #yiv6948892724 div.yiv6948892724file-title
a:visited {text-decoration:none;}#yiv6948892724 div.yiv6948892724photo-title a,
#yiv6948892724 div.yiv6948892724photo-title a:active, #yiv6948892724
div.yiv6948892724photo-title a:hover, #yiv6948892724
div.yiv6948892724photo-title a:visited {text-decoration:none;}#yiv6948892724
div#yiv6948892724ygrp-mlmsg #yiv6948892724ygrp-msg p a
span.yiv6948892724yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6948892724
.yiv6948892724green {color:#628c2a;}#yiv6948892724 .yiv6948892724MsoNormal
{margin:0 0 0 0;}#yiv6948892724 o {font-size:0;}#yiv6948892724
#yiv6948892724photos div {float:left;width:72px;}#yiv6948892724
#yiv6948892724photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6948892724
#yiv6948892724photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6948892724
#yiv6948892724reco-category {font-size:77%;}#yiv6948892724
#yiv6948892724reco-desc {font-size:77%;}#yiv6948892724 .yiv6948892724replbq
{margin:4px;}#yiv6948892724 #yiv6948892724ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6948892724 #yiv6948892724ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6948892724
#yiv6948892724ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6948892724
#yiv6948892724ygrp-mlmsg select, #yiv6948892724 input, #yiv6948892724 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6948892724
#yiv6948892724ygrp-mlmsg pre, #yiv6948892724 code {font:115%
monospace;}#yiv6948892724 #yiv6948892724ygrp-mlmsg *
{line-height:1.22em;}#yiv6948892724 #yiv6948892724ygrp-mlmsg #yiv6948892724logo
{padding-bottom:10px;}#yiv6948892724 #yiv6948892724ygrp-msg p a
{font-family:Verdana;}#yiv6948892724 #yiv6948892724ygrp-msg
p#yiv6948892724attach-count span {color:#1E66AE;font-weight:700;}#yiv6948892724
#yiv6948892724ygrp-reco #yiv6948892724reco-head
{color:#ff7900;font-weight:700;}#yiv6948892724 #yiv6948892724ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6948892724 #yiv6948892724ygrp-sponsor
#yiv6948892724ov li a {font-size:130%;text-decoration:none;}#yiv6948892724
#yiv6948892724ygrp-sponsor #yiv6948892724ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6948892724
#yiv6948892724ygrp-sponsor #yiv6948892724ov ul {margin:0;padding:0 0 0
8px;}#yiv6948892724 #yiv6948892724ygrp-text
{font-family:Georgia;}#yiv6948892724 #yiv6948892724ygrp-text p {margin:0 0 1em
0;}#yiv6948892724 #yiv6948892724ygrp-text tt {font-size:120%;}#yiv6948892724
#yiv6948892724ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6948892724 
CTV_diedit berubah warna vbaprog.xls
Description: MS-Excel spreadsheet
