  <!--<head>
<link href='https://www.blogger.com/static/v1/widgets/3566091532-css_bundle_v2.css' rel='stylesheet' type='text/css'/>
<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=2961208006956675073&zx=3f478716-09b8-415f-8aad-d45deb51178e' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=2961208006956675073&zx=3f478716-09b8-415f-8aad-d45deb51178e' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

</head>-->

Home » Microsoft excel » Conditional Formatting Text That Contains

Conditional Formatting Text That Contains

Bang Farin Jumat, 13 Maret 2015 Microsoft excel Edit

Text that contains

Text that contains yakni dipakai untuk memberi highlight pada cell yang ada nilai dari teks tersebut, untuk lebih memahami ihwal fungsi Conditional Formatting text that contain perhatikan gambar dibawah ini.

Kita akan member warna semua cell dari range Asal, Pekalongan kita semua diberi warna merah, cara untuk conditional formatting yakni sebagai berikut. Pastikan anda telah memblok range yang akan kita highlight

1. Klik Conditional Formatting

2. Pilih highlight cells rules

3. Kemudian klik Text that contains , nanti akan muncul ibarat pada gambar dibawah ini

Sehingga semua cell yang ada kalimat “Pekalongan” akan berwarna merah. Seperti pada gambar dibawah ini.

kembali ke sajian Conditional Formatting awal.

0 Response to "Conditional Formatting Text That Contains"

Posting Komentar

<!--
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY5H7mCRZqwQdaOK3-CNbCnlY9GcZw:1732346745695';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d2961208006956675073','//belajarmsexcelok.blogspot.com/2015/03/conditional-formatting-text-that.html','2961208006956675073');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '2961208006956675073', 'title': 'belajar microsoft excel', 'url': 'https://belajarmsexcelok.blogspot.com/2015/03/conditional-formatting-text-that.html', 'canonicalUrl': 'https://belajarmsexcelok.blogspot.com/2015/03/conditional-formatting-text-that.html', 'homepageUrl': 'https://belajarmsexcelok.blogspot.com/', 'searchUrl': 'https://belajarmsexcelok.blogspot.com/search', 'canonicalHomepageUrl': 'https://belajarmsexcelok.blogspot.com/', 'blogspotFaviconUrl': 'https://belajarmsexcelok.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22belajar microsoft excel - Atom\x22 href\x3d\x22https://belajarmsexcelok.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22belajar microsoft excel - RSS\x22 href\x3d\x22https://belajarmsexcelok.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22belajar microsoft excel - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/2961208006956675073/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22belajar microsoft excel - Atom\x22 href\x3d\x22https://belajarmsexcelok.blogspot.com/feeds/6717834983577969312/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Baca selengkapnya', 'pageType': 'item', 'postId': '6717834983577969312', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuKOr9nDCiKrd3o9Gw17bWmK9k9RrbXcOGRKPqZHLkMoxxQ-AgvKcBGl2I83Q4R_IFuPNIhyphenhyphenOQFNvW7odmqiNQwMQ59cXgD-lciikA6e_mBZ4WJzqtkmtVP0sMKOKQ6Gx9C9kXJF1e7OA/s72-c/conditional+formatting+text+that+contains+2.jpg', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuKOr9nDCiKrd3o9Gw17bWmK9k9RrbXcOGRKPqZHLkMoxxQ-AgvKcBGl2I83Q4R_IFuPNIhyphenhyphenOQFNvW7odmqiNQwMQ59cXgD-lciikA6e_mBZ4WJzqtkmtVP0sMKOKQ6Gx9C9kXJF1e7OA/s400/conditional+formatting+text+that+contains+2.jpg', 'pageName': 'Conditional Formatting Text That Contains', 'pageTitle': 'belajar microsoft excel: Conditional Formatting Text That Contains', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': false, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Conditional Formatting Text That Contains', 'description': 'Belajar Microsoft Excel Lengkap dari pemula sampai mahir', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuKOr9nDCiKrd3o9Gw17bWmK9k9RrbXcOGRKPqZHLkMoxxQ-AgvKcBGl2I83Q4R_IFuPNIhyphenhyphenOQFNvW7odmqiNQwMQ59cXgD-lciikA6e_mBZ4WJzqtkmtVP0sMKOKQ6Gx9C9kXJF1e7OA/s400/conditional+formatting+text+that+contains+2.jpg', 'url': 'https://belajarmsexcelok.blogspot.com/2015/03/conditional-formatting-text-that.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6717834983577969312}}]);
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidebar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile1', 'sidebar', document.getElementById('Profile1'), {}, 'displayModeFull'));
</script>
</body>-->