  <!--<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=1703947053689977276&zx=cab78a4b-553a-439b-a8c9-fa39521b3c37' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=1703947053689977276&zx=cab78a4b-553a-439b-a8c9-fa39521b3c37' 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

Adelia Puspasari Senin, 09 Februari 2015 Microsoft excel Edit

Text that contains

Text that contains ialah 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 ialah 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 menyerupai pada gambar dibawah ini

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

kembali ke hidangan 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'] = 'AOuZoY4rMQV4Mfl2HoHRIvSo2AdIRO8LEA:1732502481787';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d1703947053689977276','//belajarmicrosoftofficeok.blogspot.com/2015/02/conditional-formatting-text-that.html','1703947053689977276');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '1703947053689977276', 'title': 'belajar microsoft office', 'url': 'https://belajarmicrosoftofficeok.blogspot.com/2015/02/conditional-formatting-text-that.html', 'canonicalUrl': 'https://belajarmicrosoftofficeok.blogspot.com/2015/02/conditional-formatting-text-that.html', 'homepageUrl': 'https://belajarmicrosoftofficeok.blogspot.com/', 'searchUrl': 'https://belajarmicrosoftofficeok.blogspot.com/search', 'canonicalHomepageUrl': 'https://belajarmicrosoftofficeok.blogspot.com/', 'blogspotFaviconUrl': 'https://belajarmicrosoftofficeok.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 office - Atom\x22 href\x3d\x22https://belajarmicrosoftofficeok.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22belajar microsoft office - RSS\x22 href\x3d\x22https://belajarmicrosoftofficeok.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 office - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/1703947053689977276/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22belajar microsoft office - Atom\x22 href\x3d\x22https://belajarmicrosoftofficeok.blogspot.com/feeds/3509432054940955510/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/da8f33dd880cc4f1', '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': '3509432054940955510', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimdgt-R5hhUrIMJlKVei9JrpZpAZGuREomELcOke3Z3xm8x2a53KuAnh9fuuaSyZWzS3fkgy8b7sx4shCnsSHWtCgWk00jUrRLtYIQ33-kG4gTm9dVGkAGnntJ49NFEwT9PwDL929uDIA/s72-c/conditional+formatting+text+that+contains+2.jpg', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimdgt-R5hhUrIMJlKVei9JrpZpAZGuREomELcOke3Z3xm8x2a53KuAnh9fuuaSyZWzS3fkgy8b7sx4shCnsSHWtCgWk00jUrRLtYIQ33-kG4gTm9dVGkAGnntJ49NFEwT9PwDL929uDIA/s400/conditional+formatting+text+that+contains+2.jpg', 'pageName': 'Conditional Formatting Text That Contains', 'pageTitle': 'belajar microsoft office: Conditional Formatting Text That Contains'}}, {'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': 'T ext that contains  Text that contain s ialah dipakai untuk memberi highlight pada cell yang ada nilai dari teks tersebut, untuk lebih mema...', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimdgt-R5hhUrIMJlKVei9JrpZpAZGuREomELcOke3Z3xm8x2a53KuAnh9fuuaSyZWzS3fkgy8b7sx4shCnsSHWtCgWk00jUrRLtYIQ33-kG4gTm9dVGkAGnntJ49NFEwT9PwDL929uDIA/s400/conditional+formatting+text+that+contains+2.jpg', 'url': 'https://belajarmicrosoftofficeok.blogspot.com/2015/02/conditional-formatting-text-that.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 3509432054940955510}}]);
_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>-->