Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23

Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31

Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20

Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
{"id":1058,"date":"2019-03-20T08:19:35","date_gmt":"2019-03-20T15:19:35","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1058"},"modified":"2019-03-20T08:19:35","modified_gmt":"2019-03-20T15:19:35","slug":"highlight-rows-based-on-cell-value-in-excel","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/03\/highlight-rows-based-on-cell-value-in-excel\/","title":{"rendered":"Highlight Rows Based on Cell Value in Excel"},"content":{"rendered":"

In this tutorial, I will show you how to highlight rows based on a cell value using conditional formatting using different criteria.<\/p>\n

This can easily be done using conditional formatting in Excel.<\/p>\n

I cover the following examples in this video
\n— Highlight rows based on the text value
\n— Hight rows based on number value or date value
\n— Highlight rows that have blank cells in it
\n— Highlight rows based on multiple conditions<\/p>\n

The technique here uses conditional formatting formula that checks each cell and applies the format if the result is TRUE and does not apply the format if the result is FALSE<\/p>\n

You can read more about this and download the example file from here: https:\/\/ift.tt\/2BCBIWL<\/p>\n

-~-~~-~~~-~~-~-
\nFind Amazing Excel Tips & Tutorials: <\/p>\n

FREE Online Excel Training \u2013 Video Course for Beginners<\/a><\/p><\/blockquote>\n
<\/iframe> \n-~-~~-~~~-~~-~-<\/p>\nLet’s Connect: \nGoogle+ \u25ba https:\/\/ift.tt\/2jWiOzU \nFacebook \u25ba https:\/\/ift.tt\/2j9gyrO \nTwitter \u25ba https:\/\/twitter.com\/TrumpExcel \nPinterest \u25ba https:\/\/ift.tt\/2jWm2mZ \nYoutube Channel \u25ba https:\/\/www.youtube.com\/c\/trumpexcel<\/p>\n<div style=\"width: 480px;height: 270px;overflow: hidden\"><iframe class=\"youtube-player\" width=\"480\" height=\"270\" src=\"https:\/\/www.youtube.com\/embed\/jSGGuHDzYKg?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation\"><\/iframe><\/span><\/div>\n<a href=\"https:\/\/youtu.be\/jSGGuHDzYKg\">View on YouTube<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"In this tutorial, I will show you how to highlight rows based on a cell value using conditional formatting using different criteria. This can easily be done using conditional formatting in Excel. I cover the following examples in this video — Highlight rows based on the text value — Hight rows based on number value […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":""},"categories":[21,51,41],"tags":[20,115,22,109,105],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-h4","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/1058"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=1058"}],"version-history":[{"count":1,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/1058\/revisions"}],"predecessor-version":[{"id":1059,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/1058\/revisions\/1059"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=1058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=1058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=1058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}