{"id":172839,"date":"2023-11-04T19:12:51","date_gmt":"2023-11-04T18:12:51","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=172839"},"modified":"2023-11-04T19:14:40","modified_gmt":"2023-11-04T18:14:40","slug":"efficient-excel-data-formatting-based-on-cell-values","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values","title":{"rendered":"Efficient Excel Data Formatting Based on Cell Values"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"172839\" class=\"elementor elementor-172839\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-93f1313 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"93f1313\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f44b0de\" data-id=\"5f44b0de\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b08f3c6 elementor-widget elementor-widget-heading\" data-id=\"6b08f3c6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Conditional formatting can be used to highlight certain values or make cells easy to identify. It modifies the appearance of a range of cells according to a condition or several criteria. \nIn this article, you'll learn the tricks of conditional formatting and understand how to highlight the data you wish to advance in your analysis.  <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39e3760 elementor-widget elementor-widget-text-editor\" data-id=\"39e3760\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>We&#8217;ll be using the table below throughout the article to illustrate the various <a href=\"https:\/\/datascientest.com\/en\/how-do-i-insert-columns-and-rows-in-excel\">features of excel conditional formatting.<\/a> The table shows the price of different plant varieties according to the date on which they are sold.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6db22f3d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6db22f3d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4731f0a9\" data-id=\"4731f0a9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a3f510a elementor-widget elementor-widget-image\" data-id=\"6a3f510a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"464\" height=\"354\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple1.jpg\" class=\"attachment-large size-large wp-image-172842\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple1.jpg 464w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple1-300x229.jpg 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7cd7d69d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7cd7d69d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-790f4f64\" data-id=\"790f4f64\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14458d90 elementor-widget elementor-widget-heading\" data-id=\"14458d90\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">1\/ Conditional formatting using the Excel toolbar <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-325c81e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"325c81e2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-652a4a\" data-id=\"652a4a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-410252c4 elementor-widget elementor-widget-text-editor\" data-id=\"410252c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>First, select the range of amounts, then click on Conditional formatting in the Home tab.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-56b86b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"56b86b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a3b775a\" data-id=\"a3b775a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5fb3729e elementor-widget elementor-widget-image\" data-id=\"5fb3729e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"284\" height=\"379\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple2.jpg\" class=\"attachment-large size-large wp-image-172843\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple2.jpg 284w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple2-225x300.jpg 225w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-15ccb728 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15ccb728\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5525cff6\" data-id=\"5525cff6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ad20b2f elementor-widget elementor-widget-text-editor\" data-id=\"1ad20b2f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>If you choose Cell highlighting rules, you have several options. You can highlight amounts that are greater than, less than, between or equal to a certain amount&#8230; and even create your own rules using the &#8220;Other rules&#8230;&#8221; menu.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-478b1914 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"478b1914\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46ca6\" data-id=\"46ca6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-407b189a elementor-widget elementor-widget-image\" data-id=\"407b189a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"422\" height=\"372\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple3-1.jpg\" class=\"attachment-large size-large wp-image-172844\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple3-1.jpg 422w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple3-1-300x264.jpg 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-167bae29 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"167bae29\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2f50034c\" data-id=\"2f50034c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6540bf72 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"6540bf72\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Excel training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-79d709e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"79d709e6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-38f89fa8\" data-id=\"38f89fa8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d18fc82 elementor-widget elementor-widget-text-editor\" data-id=\"1d18fc82\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Example 1<\/p><p>When you select &#8220;less than&#8221;, you can enter a maximum amount (e.g. 10) below which the values will be highlighted, as shown below: all plants priced under \u20ac10 will be highlighted using the custom format you&#8217;ve chosen. Here, cells meeting this criterion are highlighted in blue with red characters.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2cc52514 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2cc52514\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5bf0bfba\" data-id=\"5bf0bfba\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c590041 elementor-widget elementor-widget-image\" data-id=\"1c590041\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"147\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple4.jpg\" class=\"attachment-large size-large wp-image-172845\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple4.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple4-300x73.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-33e16878 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"33e16878\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5d260a8d\" data-id=\"5d260a8d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-621adf5d elementor-widget elementor-widget-image\" data-id=\"621adf5d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"526\" height=\"446\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple5.jpg\" class=\"attachment-large size-large wp-image-172846\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple5.jpg 526w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple5-300x254.jpg 300w\" sizes=\"(max-width: 526px) 100vw, 526px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14f6cf1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14f6cf1d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61bd223d\" data-id=\"61bd223d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6491f3 elementor-widget elementor-widget-text-editor\" data-id=\"b6491f3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Example 2<\/strong><\/p><p>You can also highlight all cells containing a certain text, or dates occurring yesterday, today, tomorrow, in the last 7 days, last week, this week, next week, last month, this month or next month.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3239364e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3239364e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-257105e6\" data-id=\"257105e6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f24cae3 elementor-widget elementor-widget-image\" data-id=\"2f24cae3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"564\" height=\"268\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple6.jpg\" class=\"attachment-large size-large wp-image-172847\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple6.jpg 564w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple6-300x143.jpg 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-598cd135 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"598cd135\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25f8626c\" data-id=\"25f8626c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c6ecc48 elementor-widget elementor-widget-text-editor\" data-id=\"c6ecc48\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>You can also choose Set high\/low range values. If you want to highlight the 5 highest values in red, select &#8220;10 highest values&#8221; and replace 10 with 5 in the dialog box. You can then change the format in which you want your values to appear (e.g. Light red fill with dark red text).<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2961b880 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2961b880\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5208043a\" data-id=\"5208043a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-30d5278c elementor-widget elementor-widget-image\" data-id=\"30d5278c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"584\" height=\"454\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple7.jpg\" class=\"attachment-large size-large wp-image-172848\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple7.jpg 584w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple7-300x233.jpg 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7e86d9a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e86d9a1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-eb1477d\" data-id=\"eb1477d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f64e344 elementor-widget elementor-widget-image\" data-id=\"1f64e344\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"572\" height=\"200\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple8.jpg\" class=\"attachment-large size-large wp-image-172849\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple8.jpg 572w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple8-300x105.jpg 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-45856851 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45856851\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b84576f\" data-id=\"4b84576f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-55703ee elementor-widget elementor-widget-text-editor\" data-id=\"55703ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This is what you get:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c601c2b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c601c2b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6f1d7176\" data-id=\"6f1d7176\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-39023c66 elementor-widget elementor-widget-image\" data-id=\"39023c66\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"379\" height=\"446\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple9.jpg\" class=\"attachment-large size-large wp-image-172850\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple9.jpg 379w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple9-255x300.jpg 255w\" sizes=\"(max-width: 379px) 100vw, 379px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cf0848f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf0848f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6229cf24\" data-id=\"6229cf24\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52545025 elementor-widget elementor-widget-text-editor\" data-id=\"52545025\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>You can also select Data Bars, Color Shades or Icon Sets.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d7e5c23 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d7e5c23\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ff62b0a\" data-id=\"5ff62b0a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c48fb39 elementor-widget elementor-widget-text-editor\" data-id=\"5c48fb39\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Example with icon set<\/p><p>Choose 3, 4 or 5 icons, depending on the number of slices you require.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-22a10e15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22a10e15\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6eb76964\" data-id=\"6eb76964\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b30b70 elementor-widget elementor-widget-image\" data-id=\"4b30b70\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"233\" height=\"205\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple10.jpg\" class=\"attachment-large size-large wp-image-172851\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-323f2a49 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"323f2a49\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5fd7b556\" data-id=\"5fd7b556\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-281c188c elementor-widget elementor-widget-image\" data-id=\"281c188c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"263\" height=\"223\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple11.jpg\" class=\"attachment-large size-large wp-image-172852\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f142db0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f142db0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-79bf25a\" data-id=\"79bf25a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ee645a elementor-widget elementor-widget-text-editor\" data-id=\"4ee645a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>To modify these rules as you wish, click on Home \/ Conditional formatting \/ Manage rules.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5b12cc92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b12cc92\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-59adbf5b\" data-id=\"59adbf5b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bb1a7d6 elementor-widget elementor-widget-image\" data-id=\"bb1a7d6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"216\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple12.jpg\" class=\"attachment-large size-large wp-image-172853\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple12.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple12-300x108.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2374c78e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2374c78e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ad9f102\" data-id=\"3ad9f102\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7ad3c3d9 elementor-widget elementor-widget-text-editor\" data-id=\"7ad3c3d9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>And double-clicking on the Icon set rule produces :<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4a52768d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4a52768d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1ea9d931\" data-id=\"1ea9d931\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5af3c662 elementor-widget elementor-widget-image\" data-id=\"5af3c662\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"517\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple13.jpg\" class=\"attachment-large size-large wp-image-172854\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple13.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple13-300x258.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b04adca elementor-widget elementor-widget-text-editor\" data-id=\"2b04adca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>(To be modified as desired)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f5e8f07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f5e8f07\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-62c7d433\" data-id=\"62c7d433\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4e6a19bf elementor-widget elementor-widget-text-editor\" data-id=\"4e6a19bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you have defined more than one rule for a cell range, and you have ticked Interrupt if true, the subsequent rules will no longer be applied if the first is true.<\/p><p>Please note: when you copy\/paste cells, the conditional formatting is also copied.<\/p><p>Don&#8217;t hesitate to go to Manage rules in Home \/ Conditional formatting to create, modify or delete a rule. Look carefully at the cell ranges to which these rules apply.<\/p><p>As you need to select the cell range before modifying the rules, it would be a good idea to name this range in the Formulas \/ Define name ribbon, so that you can find your way around if your <a href=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\">Excel sheet contains a lot of data.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f1098d7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f1098d7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c9f445a\" data-id=\"6c9f445a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a373951 elementor-widget elementor-widget-image\" data-id=\"6a373951\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"454\" height=\"348\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple14.jpg\" class=\"attachment-large size-large wp-image-172855\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple14.jpg 454w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple14-300x230.jpg 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6a21bbc2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a21bbc2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2690046d\" data-id=\"2690046d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6cd2ad9b elementor-widget elementor-widget-text-editor\" data-id=\"6cd2ad9b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Then simply select the name from the drop-down list on the left of the formula bar, before modifying the conditional formatting rules.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c81fe39 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c81fe39\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-54bdd38f\" data-id=\"54bdd38f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1b170018 elementor-widget elementor-widget-image\" data-id=\"1b170018\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"69\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple15.jpg\" class=\"attachment-large size-large wp-image-172856\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple15.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple15-300x34.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-35d85ced elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"35d85ced\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-366a196e\" data-id=\"366a196e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51f9f2a8 elementor-widget elementor-widget-text-editor\" data-id=\"51f9f2a8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You can also change the priority of rules using the arrow keys.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-21b65c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21b65c2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3a1249a0\" data-id=\"3a1249a0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ce455d1 elementor-widget elementor-widget-heading\" data-id=\"1ce455d1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2\/ Formatting an entire line<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-44b94ce5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44b94ce5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7bc8b836\" data-id=\"7bc8b836\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f1364a1 elementor-widget elementor-widget-text-editor\" data-id=\"4f1364a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Even more interesting! Excel also lets you color an entire row, not just a single column, according to the value of a column:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1fcf4746 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fcf4746\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5c61618c\" data-id=\"5c61618c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-479affcc elementor-widget elementor-widget-image\" data-id=\"479affcc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"266\" height=\"296\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple16.jpg\" class=\"attachment-large size-large wp-image-172857\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43546f80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43546f80\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6cc41f2e\" data-id=\"6cc41f2e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1b2ddc57 elementor-widget elementor-widget-image\" data-id=\"1b2ddc57\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"263\" height=\"317\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple17.jpg\" class=\"attachment-large size-large wp-image-172858\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple17.jpg 263w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple17-249x300.jpg 249w\" sizes=\"(max-width: 263px) 100vw, 263px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-553ad52d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"553ad52d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1615b6c\" data-id=\"1615b6c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7544bda9 elementor-widget elementor-widget-text-editor\" data-id=\"7544bda9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To obtain the table on the left, select the range of cells corresponding to the Plant column, then click on the Home \/ Conditional formatting tab and select the type of rule: Apply formatting only to cells containing the plant.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f6d5528 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f6d5528\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4892cbcb\" data-id=\"4892cbcb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5679b9c5 elementor-widget elementor-widget-image\" data-id=\"5679b9c5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple18.jpg\" class=\"attachment-large size-large wp-image-172859\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple18.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple18-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-600e9307 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"600e9307\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dd3c909\" data-id=\"dd3c909\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d45508 elementor-widget elementor-widget-text-editor\" data-id=\"4d45508\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To obtain the table on the right, select the entire table and use a formula with a mixed reference: freeze the column but not the row, i.e. put a dollar in front of the column and nothing in front of the row, or press the F4 or Fn F4 key 3 times:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6e578a39 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e578a39\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4c08ec88\" data-id=\"4c08ec88\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-706eeb99 elementor-widget elementor-widget-image\" data-id=\"706eeb99\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple19.jpg\" class=\"attachment-large size-large wp-image-172860\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple19.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple19-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-68a5100d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"68a5100d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-347ce046\" data-id=\"347ce046\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-921ede4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"921ede4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e783354 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e783354\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7a0523ff\" data-id=\"7a0523ff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-736e76d elementor-widget elementor-widget-heading\" data-id=\"736e76d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3\/ Inserting functions into conditional formatting<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-16b7a748 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16b7a748\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5eb43bfd\" data-id=\"5eb43bfd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-490e20c3 elementor-widget elementor-widget-text-editor\" data-id=\"490e20c3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You can also insert all Excel&#8217;s functions into conditional formatting if you choose to use a formula to determine for which cells the format will be applied.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a0729b6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a0729b6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1bfb4f54\" data-id=\"1bfb4f54\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-631cd7a2 elementor-widget elementor-widget-text-editor\" data-id=\"631cd7a2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Case study 1<\/p><p>Show the start and end dates of plant sales on a schedule as above. Freeze the column for the start and end dates and the row for the month dates with mixed references and use the AND function.<\/p><p>Select the grid cell range in the table and select Home \/ Conditional Formatting \/ Use a formula to determine for which cells the format will be applied:<\/p><p>Write the formula: =ET(F$3&gt;=$A4;F$3&lt;=$B4) then click on the Format&#8230; button and the Fill tab.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-452711f1 elementor-widget elementor-widget-image\" data-id=\"452711f1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"109\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple20.jpg\" class=\"attachment-large size-large wp-image-172861\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple20.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple20-300x54.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3d0c4a54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d0c4a54\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46a0bd68\" data-id=\"46a0bd68\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-442a5aca elementor-widget elementor-widget-image\" data-id=\"442a5aca\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple21.jpg\" class=\"attachment-large size-large wp-image-172862\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple21.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple21-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-724bde36 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"724bde36\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-58a4d8ae\" data-id=\"58a4d8ae\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6906b200 elementor-widget elementor-widget-text-editor\" data-id=\"6906b200\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Case study 2<\/p><p>Highlighting weekends and the current date in a schedule<\/p><p>Let&#8217;s create two rulers by clicking on New Ruler then Use formula to determine for which cells the format will be applied and in the Apply formatting to values for which this formula is true, enter your formula. You can&#8217;t automatically insert the functions, you need to know them.<\/p><p>Click again on New Ruler or in Manage Rulers to see all the rulers in your selection.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ec7645 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ec7645\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-251b1fac\" data-id=\"251b1fac\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6fae5575 elementor-widget elementor-widget-image\" data-id=\"6fae5575\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple22.jpg\" class=\"attachment-large size-large wp-image-172863\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple22.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple22-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-633a732d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"633a732d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9e22f8b\" data-id=\"9e22f8b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-507ed9db elementor-widget elementor-widget-text-editor\" data-id=\"507ed9db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here are the two formulas to write:<\/p><p>=F$10=TODAY()<\/p><p>=OR(JOURSEM(F$10)=7;JOURSEM(F$10)=1)<\/p><p>Set a mixed reference by freezing the line containing all the dates of the month and use the Joursem function, which returns a number from 1 to 7 from Sunday to Saturday.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e38bb27 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e38bb27\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3d28f4d9\" data-id=\"3d28f4d9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3255f224 elementor-widget elementor-widget-image\" data-id=\"3255f224\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"216\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple23.jpg\" class=\"attachment-large size-large wp-image-172864\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple23.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple23-300x108.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-417d657d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"417d657d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3635bd0\" data-id=\"3635bd0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-200ef897 elementor-widget elementor-widget-text-editor\" data-id=\"200ef897\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You can return to the formulas by clicking on Manage rules and double-clicking on the rule you wish to modify.<\/p><p>The result is as follows:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8bdc464 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8bdc464\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6162c43e\" data-id=\"6162c43e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c4ba371 elementor-widget elementor-widget-image\" data-id=\"c4ba371\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"121\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple24.jpg\" class=\"attachment-large size-large wp-image-172865\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple24.jpg 602w, https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-mise-en-forme-conditionnelle-exemple24-300x60.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c786967 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c786967\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-65f2e28a\" data-id=\"65f2e28a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fefb5fc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1fefb5fc\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn more about Excel functions<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Conditional formatting can be used to highlight certain values or make cells easy to identify. It modifies the appearance of a range of cells according to a condition or several criteria. In this article, you&#8217;ll learn the tricks of conditional formatting and understand how to highlight the data you wish to advance in your analysis. [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":172840,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Efficient Excel Data Formatting Based on Cell Values<\/title>\n<meta name=\"description\" content=\"Discover the best practices for formatting Excel table data according to the values within cells. Learn how to make your spreadsheets visually appealing and informative with simple and effective techniques...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Efficient Excel Data Formatting Based on Cell Values\" \/>\n<meta property=\"og:description\" content=\"Conditional formatting can be used to highlight certain values or make cells easy to identify. It modifies the appearance of a range of cells according to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-04T18:12:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-04T18:14:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-makro.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Efficient Excel Data Formatting Based on Cell Values\",\"datePublished\":\"2023-11-04T18:12:51+00:00\",\"dateModified\":\"2023-11-04T18:14:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"},\"wordCount\":898,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\",\"url\":\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\",\"name\":\"Efficient Excel Data Formatting Based on Cell Values\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-04T18:12:51+00:00\",\"dateModified\":\"2023-11-04T18:14:40+00:00\",\"description\":\"Discover the best practices for formatting Excel table data according to the values within cells. Learn how to make your spreadsheets visually appealing and informative with simple and effective techniques...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Efficient Excel Data Formatting Based on Cell Values","description":"Discover the best practices for formatting Excel table data according to the values within cells. Learn how to make your spreadsheets visually appealing and informative with simple and effective techniques...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values","og_locale":"en_GB","og_type":"article","og_title":"Efficient Excel Data Formatting Based on Cell Values","og_description":"Conditional formatting can be used to highlight certain values or make cells easy to identify. It modifies the appearance of a range of cells according to","og_url":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-04T18:12:51+00:00","article_modified_time":"2023-11-04T18:14:40+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/excel-makro.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Efficient Excel Data Formatting Based on Cell Values","datePublished":"2023-11-04T18:12:51+00:00","dateModified":"2023-11-04T18:14:40+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values"},"wordCount":898,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values","url":"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values","name":"Efficient Excel Data Formatting Based on Cell Values","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-04T18:12:51+00:00","dateModified":"2023-11-04T18:14:40+00:00","description":"Discover the best practices for formatting Excel table data according to the values within cells. Learn how to make your spreadsheets visually appealing and informative with simple and effective techniques...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/172839"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=172839"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/172839\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/172840"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=172839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=172839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=172839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}