{"id":159735,"date":"2022-06-01T10:27:54","date_gmt":"2022-06-01T09:27:54","guid":{"rendered":"https:\/\/datascientest.com\/?p=159735"},"modified":"2024-02-13T16:08:56","modified_gmt":"2024-02-13T16:08:56","slug":"excel-mise-en-forme-conditionnelle","status":"publish","type":"post","link":"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle","title":{"rendered":"Comment mettre en forme les donn\u00e9es d\u2019un tableau Excel en fonction de ses valeurs ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"159735\" class=\"elementor elementor-159735\" 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-927b6c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"927b6c2\" 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-4caa396\" data-id=\"4caa396\" 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-b2363e2 elementor-widget elementor-widget-heading\" data-id=\"b2363e2\" 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\">La mise en forme conditionnelle permet de mettre en \u00e9vidence certaines valeurs ou de rendre des cellules faciles \u00e0 identifier. Elle modifie l'apparence d'une plage de cellules en fonction d'une condition ou de plusieurs crit\u00e8res.\u00a0\nDans cet article, vous allez apprendre les astuces de la mise en forme conditionnelle et comprendre comment mettre en \u00e9vidence les donn\u00e9es que vous souhaitez avancer dans votre analyse.\u00a0\u00a0<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5fd4efd elementor-widget elementor-widget-text-editor\" data-id=\"5fd4efd\" 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>Nous utiliserons le tableau ci-dessous tout au long de l\u2019article afin d\u2019illustrer <strong>les diff\u00e9rentes fonctionnalit\u00e9s de la mise en forme conditionnelle excel<\/strong>. Le tableau le prix de diff\u00e9rentes vari\u00e9t\u00e9s de plantes en fonction de la date \u00e0 laquelle elles sont vendues.\u00a0<\/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-e54bc62 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e54bc62\" 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-7b9e21a\" data-id=\"7b9e21a\" 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-bcdff9b elementor-widget elementor-widget-image\" data-id=\"bcdff9b\" 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\t\t\t<img decoding=\"async\" width=\"464\" height=\"354\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple1-1.jpg\" class=\"attachment-large size-large wp-image-159738\" alt=\"excel-mise-en-forme-conditionnelle-exemple(1)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple1-1.jpg 464w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple1-1-300x229.jpg 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/>\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-483948b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"483948b\" 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-c7f24ba\" data-id=\"c7f24ba\" 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-6243ec4 elementor-widget elementor-widget-heading\" data-id=\"6243ec4\" 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\/ Mise en forme conditionnelle \u00e0 l\u2019aide du Ruban Excel <\/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-643a548 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"643a548\" 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-a144928\" data-id=\"a144928\" 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-d6c3115 elementor-widget elementor-widget-text-editor\" data-id=\"d6c3115\" 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>Dans un premier temps, s\u00e9lectionnez la plage des montants puis cliquez sur <b>Mise en forme conditionnelle <\/b>de l\u2019onglet <b>Accueil.<\/b><\/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-380210a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"380210a\" 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-c3ccb72\" data-id=\"c3ccb72\" 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-1399d31 elementor-widget elementor-widget-image\" data-id=\"1399d31\" 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=\"284\" height=\"379\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple2-1.jpg\" class=\"attachment-large size-large wp-image-159739\" alt=\"excel-mise-en-forme-conditionnelle-exemple(2)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple2-1.jpg 284w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple2-1-225x300.jpg 225w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/>\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-bf21191 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf21191\" 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-307f17b\" data-id=\"307f17b\" 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-10bdf82 elementor-widget elementor-widget-text-editor\" data-id=\"10bdf82\" 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>Si vous choisissez <b>R\u00e8gles de mise en surbrillance des cellules<\/b>, plusieurs options s\u2019offrent \u00e0 vous. Vous pouvez surligner les montants qui sont sup\u00e9rieurs,\u00a0 inf\u00e9rieurs \u00e0 un certain montant, compris entre deux montants, \u00e9gaux \u00e0 un certain montant\u2026 et m\u00eame constituer vos propres r\u00e8gles \u00e0 l\u2019aide du menu \u201cAutres r\u00e8gles\u2026\u201d<\/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-9e2ca8d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e2ca8d\" 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-c17a0b0\" data-id=\"c17a0b0\" 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-91e63f4 elementor-widget elementor-widget-image\" data-id=\"91e63f4\" 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=\"422\" height=\"372\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple3-1-1.jpg\" class=\"attachment-large size-large wp-image-159741\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple3-1-1.jpg 422w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple3-1-1-300x264.jpg 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/>\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-a14f3b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a14f3b0\" 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-1491138\" data-id=\"1491138\" 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-9b1ef96 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9b1ef96\" 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\/formation-power-bi\">\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\">Se former en analyse de donn\u00e9es<\/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-77d1258 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77d1258\" 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-114bbf1\" data-id=\"114bbf1\" 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-8bc3697 elementor-widget elementor-widget-text-editor\" data-id=\"8bc3697\" 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><span style=\"text-decoration: underline;\">Exemple 1<\/span><\/strong><\/p><p>Lorsque vous s\u00e9lectionnez <strong>\u201cinf\u00e9rieur \u00e0\u201d<\/strong>, vous pouvez saisir un montant maximum (ex: 10) en dessous duquel les valeurs seront mises en surbrillance comme ci-dessous : toutes les plantes dont le prix est inf\u00e9rieur \u00e0 10\u20ac seront mises en surbrillance gr\u00e2ce au format personnalis\u00e9 que vous aurez choisi. Ici, les cellules remplissant ce crit\u00e8re ressortent bleues avec des caract\u00e8res rouges.<\/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-6b6c8ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b6c8ac\" 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-0f30e11\" data-id=\"0f30e11\" 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-f10a0f7 elementor-widget elementor-widget-image\" data-id=\"f10a0f7\" 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=\"602\" height=\"147\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple4-1.jpg\" class=\"attachment-large size-large wp-image-159742\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple4-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple4-1-300x73.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-0bf86cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0bf86cc\" 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-fa83cf7\" data-id=\"fa83cf7\" 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-a6bb881 elementor-widget elementor-widget-image\" data-id=\"a6bb881\" 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=\"526\" height=\"446\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple5-1.jpg\" class=\"attachment-large size-large wp-image-159743\" alt=\"excel-mise-en-forme-conditionnelle-exemple(5)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple5-1.jpg 526w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple5-1-300x254.jpg 300w\" sizes=\"(max-width: 526px) 100vw, 526px\" \/>\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-f72eef4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f72eef4\" 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-38990b2\" data-id=\"38990b2\" 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-3ff0598 elementor-widget elementor-widget-text-editor\" data-id=\"3ff0598\" 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><span style=\"text-decoration: underline\"><strong>Exemple 2<\/strong><\/span><\/p><p>Vous pouvez \u00e9galement faire ressortir toutes les cellules contenant un certain texte, ou des dates se produisant hier, aujourd\u2019hui, demain, dans les 7 derniers jours, la semaine derni\u00e8re, cette semaine, la semaine prochaine, le mois dernier, ce mois, ou le mois prochain<\/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-2320f2b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2320f2b\" 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-c6b0b30\" data-id=\"c6b0b30\" 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-3370c55 elementor-widget elementor-widget-image\" data-id=\"3370c55\" 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=\"564\" height=\"268\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple6-1.jpg\" class=\"attachment-large size-large wp-image-159744\" alt=\"excel-mise-en-forme-conditionnelle-exemple(6)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple6-1.jpg 564w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple6-1-300x143.jpg 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/>\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-65da15c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65da15c\" 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-e0f67a1\" data-id=\"e0f67a1\" 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-803fd45 elementor-widget elementor-widget-text-editor\" data-id=\"803fd45\" 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>Vous pouvez aussi choisir <b>R\u00e8gle des valeurs de plage haute\/ basse<\/b>. Si vous voulez mettre en rouge les 5 valeurs les plus \u00e9lev\u00e9es, il vous faut s\u00e9lectionner \u201c10 valeurs les plus \u00e9lev\u00e9es\u201d puis remplacer 10 par 5 dans la bo\u00eete de dialogue. Vous pouvez ensuite modifier le format dans lequel vous souhaitez faire appara\u00eetre vos valeurs (ex: Remplissage rouge clair avec texte rouge fonc\u00e9).<\/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-6db4598 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6db4598\" 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-f0bd7bb\" data-id=\"f0bd7bb\" 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-980652c elementor-widget elementor-widget-image\" data-id=\"980652c\" 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=\"584\" height=\"454\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple7-1.jpg\" class=\"attachment-large size-large wp-image-159745\" alt=\"excel-mise-en-forme-conditionnelle-exemple(7)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple7-1.jpg 584w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple7-1-300x233.jpg 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/>\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-4330356 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4330356\" 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-4565b63\" data-id=\"4565b63\" 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-cdfe1b0 elementor-widget elementor-widget-image\" data-id=\"cdfe1b0\" 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=\"572\" height=\"200\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple8-1.jpg\" class=\"attachment-large size-large wp-image-159746\" alt=\"excel-mise-en-forme-conditionnelle-exemple(8)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple8-1.jpg 572w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple8-1-300x105.jpg 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/>\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-6edb582 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6edb582\" 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-05c6e60\" data-id=\"05c6e60\" 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-01bf495 elementor-widget elementor-widget-text-editor\" data-id=\"01bf495\" 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>Vous obtenez ceci :<\/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-3112c54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3112c54\" 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-6fa79e2\" data-id=\"6fa79e2\" 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-a6329a9 elementor-widget elementor-widget-image\" data-id=\"a6329a9\" 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=\"379\" height=\"446\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple9-1.jpg\" class=\"attachment-large size-large wp-image-159747\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple9-1.jpg 379w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple9-1-255x300.jpg 255w\" sizes=\"(max-width: 379px) 100vw, 379px\" \/>\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-270ab77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"270ab77\" 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-8514b6f\" data-id=\"8514b6f\" 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-815ad73 elementor-widget elementor-widget-text-editor\" data-id=\"815ad73\" 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>Vous pouvez aussi choisir <b>Barres de donn\u00e9es, Nuances de couleurs <\/b>ou<b> Jeux d\u2019ic\u00f4nes<\/b>.<\/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-632723b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"632723b\" 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-8d540f5\" data-id=\"8d540f5\" 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-d246904 elementor-widget elementor-widget-text-editor\" data-id=\"d246904\" 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><span style=\"text-decoration: underline\"><strong>Exemple avec Jeu d\u2019ic\u00f4nes<\/strong><\/span><\/p><p>Choisissez 3,4 ou 5 ic\u00f4nes selon le nombre de tranches que vous souhaitez.<\/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-1f2bf39 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f2bf39\" 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-3fa58c5\" data-id=\"3fa58c5\" 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-1f0a0bb elementor-widget elementor-widget-image\" data-id=\"1f0a0bb\" 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=\"233\" height=\"205\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple10-1.jpg\" class=\"attachment-large size-large wp-image-159748\" alt=\"excel-mise-en-forme-conditionnelle-exemple(10)\" \/>\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-f3754f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3754f8\" 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-c3b45b1\" data-id=\"c3b45b1\" 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-3c3faba elementor-widget elementor-widget-image\" data-id=\"3c3faba\" 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\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple11-1.jpg\" class=\"attachment-large size-large wp-image-159749\" alt=\"excel-mise-en-forme-conditionnelle-exemple(11)\" \/>\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-46b24a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"46b24a4\" 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-b6199d8\" data-id=\"b6199d8\" 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-1bd1902 elementor-widget elementor-widget-text-editor\" data-id=\"1bd1902\" 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>Pour modifier ces r\u00e8gles \u00e0 votre convenance, cliquez dans <b>Accueil \/Mise en forme conditionnelle \/G\u00e9rer les r\u00e8gles.<\/b><\/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-b256c46 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b256c46\" 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-c1b7438\" data-id=\"c1b7438\" 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-707df82 elementor-widget elementor-widget-image\" data-id=\"707df82\" 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=\"602\" height=\"216\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple12-1.jpg\" class=\"attachment-large size-large wp-image-159750\" alt=\"excel-mise-en-forme-conditionnelle-exemple(12)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple12-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple12-1-300x108.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-830c75f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"830c75f\" 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-2d37dae\" data-id=\"2d37dae\" 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-f3cb7dc elementor-widget elementor-widget-text-editor\" data-id=\"f3cb7dc\" 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>Et en double cliquant sur la r\u00e8gle Jeu d\u2019ic\u00f4nes on obtient :<\/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-8a8283b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a8283b\" 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-35a7351\" data-id=\"35a7351\" 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-72681c5 elementor-widget elementor-widget-image\" data-id=\"72681c5\" 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=\"602\" height=\"517\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple13-1.jpg\" class=\"attachment-large size-large wp-image-159751\" alt=\"excel-mise-en-forme-conditionnelle-exemple(13)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple13-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple13-1-300x258.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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<div class=\"elementor-element elementor-element-6470d3c elementor-widget elementor-widget-text-editor\" data-id=\"6470d3c\" 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>(\u00c0 modifier comme on le souhaite)<\/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-fa0d8e9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa0d8e9\" 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-e1c940b\" data-id=\"e1c940b\" 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-dee6680 elementor-widget elementor-widget-text-editor\" data-id=\"dee6680\" 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><span style=\"color: #000000;\">Si on a d\u00e9fini plusieurs r\u00e8gles pour <strong>une plage de cellule<\/strong> et que l\u2019on a coch\u00e9 Interrompre si vrai les r\u00e8gles suivantes ne seront plus appliqu\u00e9es si la premi\u00e8re est vraie.<\/span><\/p><p><span style=\"color: #000000;\"><b>Attention :<\/b> quand on copie \/ colle des cellules, la mise en forme conditionnelle est aussi copi\u00e9e.<\/span><\/p><p><span style=\"color: #000000;\">N\u2019h\u00e9sitez pas \u00e0 aller dans <b>G\u00e9rer les r\u00e8gles<\/b> dans <b>Accueil \/ Mise en forme conditionnelle<\/b> pour cr\u00e9er, modifier ou supprimer une r\u00e8gle. Regardez bien les plages de cellules auxquelles ces r\u00e8gles s\u2019appliquent.\u00a0<\/span><\/p><p><span style=\"color: #000000;\">Comme il faut bien s\u00e9lectionner la plage de cellules avant de modifier les r\u00e8gles, il serait judicieux de nommer cette plage dans le ruban <b>Formules \/ D\u00e9finir un nom<\/b> afin de pouvoir se retrouver si votre feuille <a style=\"color: #000000;\" href=\"https:\/\/www.microsoft.com\/fr-fr\/microsoft-365\/excel\">Excel<\/a> contient beaucoup de donn\u00e9es.\u00a0\u00a0<\/span><\/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-73d1e3b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"73d1e3b\" 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-66cf863\" data-id=\"66cf863\" 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-70d2eb4 elementor-widget elementor-widget-image\" data-id=\"70d2eb4\" 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=\"454\" height=\"348\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple14-1.jpg\" class=\"attachment-large size-large wp-image-159752\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple14-1.jpg 454w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple14-1-300x230.jpg 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/>\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-f6ea459 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f6ea459\" 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-13a8ad0\" data-id=\"13a8ad0\" 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-0f082f3 elementor-widget elementor-widget-text-editor\" data-id=\"0f082f3\" 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>Et ensuite il suffit de s\u00e9lectionner le nom dans la <strong>liste d\u00e9roulante<\/strong> \u00e0 gauche de la barre de formule, avant de modifier les r\u00e8gles de la mise en forme conditionnelle.<\/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-02ff02b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"02ff02b\" 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-cbe91ad\" data-id=\"cbe91ad\" 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-ea0d41f elementor-widget elementor-widget-image\" data-id=\"ea0d41f\" 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=\"602\" height=\"69\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple15-1.jpg\" class=\"attachment-large size-large wp-image-159753\" alt=\"excel-mise-en-forme-conditionnelle-exemple(15)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple15-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple15-1-300x34.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-f2f892d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2f892d\" 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-0560797\" data-id=\"0560797\" 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-236875d elementor-widget elementor-widget-text-editor\" data-id=\"236875d\" 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>On peut aussi modifier la priorit\u00e9 des r\u00e8gles avec les fl\u00e8che.<\/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-cb88874 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb88874\" 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-184b51a\" data-id=\"184b51a\" 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-9f2f08c elementor-widget elementor-widget-heading\" data-id=\"9f2f08c\" 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\/ Mettre en forme toute une ligne<\/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-ab3e531 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ab3e531\" 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-783c63e\" data-id=\"783c63e\" 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-c426101 elementor-widget elementor-widget-text-editor\" data-id=\"c426101\" 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>Plus int\u00e9ressant ! Excel permet \u00e9galement de mettre toute une ligne et non seulement une colonne en couleur en fonction de la valeur d\u2019une colonne :<\/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-14c31e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14c31e8\" 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-ebc9405\" data-id=\"ebc9405\" 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-06a532c elementor-widget elementor-widget-image\" data-id=\"06a532c\" 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=\"266\" height=\"296\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple16-1.jpg\" class=\"attachment-large size-large wp-image-159754\" 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-4f1e823 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f1e823\" 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-482fe83\" data-id=\"482fe83\" 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-856f6eb elementor-widget elementor-widget-image\" data-id=\"856f6eb\" 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=\"317\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple17-1.jpg\" class=\"attachment-large size-large wp-image-159755\" alt=\"excel-mise-en-forme-conditionnelle-exemple(17)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple17-1.jpg 263w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple17-1-249x300.jpg 249w\" sizes=\"(max-width: 263px) 100vw, 263px\" \/>\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-bf522be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf522be\" 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-6dc894e\" data-id=\"6dc894e\" 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-1c5d579 elementor-widget elementor-widget-text-editor\" data-id=\"1c5d579\" 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>Pour obtenir le tableau de gauche il faut s\u00e9lectionner la plage de cellules qui correspond \u00e0 <b>la colonne<\/b> Plante puis cliquer\u00a0 sur l\u2019onglet Accueil \/ Mise en forme conditionnelle, s\u00e9lectionnez le type de r\u00e8gle : Appliquer une mise en forme uniquement aux cellules qui contiennent.<\/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-0d6dbec elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d6dbec\" 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-b578cb4\" data-id=\"b578cb4\" 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-1d906a9 elementor-widget elementor-widget-image\" data-id=\"1d906a9\" 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=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple18-1.jpg\" class=\"attachment-large size-large wp-image-159756\" alt=\"excel-mise-en-forme-conditionnelle-exemple(18)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple18-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple18-1-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-37f770b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37f770b\" 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-034f928\" data-id=\"034f928\" 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-b57703e elementor-widget elementor-widget-text-editor\" data-id=\"b57703e\" 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>Pour obtenir le tableau de droite il faut s\u00e9lectionner <b>tout le tableau<\/b> et utiliser une formule avec une r\u00e9f\u00e9rence mixte : figer la colonne mais pas la ligne, c\u2019est-\u00e0-dire mettre un dollar devant la colonne et rien devant la ligne ou appuyer 3 fois sur la touche F4 ou Fn F4 :<\/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-e48a779 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e48a779\" 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-6467b74\" data-id=\"6467b74\" 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-c2a7c85 elementor-widget elementor-widget-image\" data-id=\"c2a7c85\" 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=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple19-1.jpg\" class=\"attachment-large size-large wp-image-159757\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple19-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple19-1-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-c84ad00 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c84ad00\" 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-7847c04\" data-id=\"7847c04\" 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-7d01759 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7d01759\" 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\/formation-power-bi\">\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\">Se renseigner sur notre formation Power BI<\/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-968e032 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"968e032\" 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-f33da0b\" data-id=\"f33da0b\" 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-f51808a elementor-widget elementor-widget-heading\" data-id=\"f51808a\" 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\/ Insertion de fonctions dans la mise en forme conditionnelle<\/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-5751f40 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5751f40\" 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-371680d\" data-id=\"371680d\" 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-1a0d62c elementor-widget elementor-widget-text-editor\" data-id=\"1a0d62c\" 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>On peut aussi ins\u00e9rer toutes les fonctions d\u2019Excel dans la mise en forme conditionnelle si on choisit <b>utiliser une formule pour d\u00e9terminer pour quelles cellules le format sera appliqu\u00e9<\/b>.<\/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-8d3ef66 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d3ef66\" 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-5e1c22c\" data-id=\"5e1c22c\" 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-9ad2f63 elementor-widget elementor-widget-image\" data-id=\"9ad2f63\" 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=\"602\" height=\"109\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple20-1.jpg\" class=\"attachment-large size-large wp-image-159758\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple20-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple20-1-300x54.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-500e0ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"500e0ea\" 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-b96b4ad\" data-id=\"b96b4ad\" 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-881f7a9 elementor-widget elementor-widget-text-editor\" data-id=\"881f7a9\" 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><span style=\"text-decoration: underline;\"><b><i>Cas pratique 1<\/i><\/b><\/span><\/p><p>Repr\u00e9senter sur un planning les dates de d\u00e9but et de fin de vente des plantes comme ci-dessus. Figer la colonne pour les dates de d\u00e9but et de fin et la ligne pour les dates du mois avec des r\u00e9f\u00e9rences mixtes et utiliser la fonction ET.<\/p><p>Il faut s\u00e9lectionner la plage de cellules quadrill\u00e9e du tableau et faire Accueil\/ Mise en Forme Conditionnelle \/ Utiliser une formule pour d\u00e9terminer pour quelles cellules le format sera appliqu\u00e9 :<\/p><p>Ecrire la formule : <strong>=ET(F$3&gt;=$A4;F$3&lt;=$B4) <\/strong>puis cliquez sur le bouton Format\u2026 et onglet Remplissage<\/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-203075d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"203075d\" 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-b7b7409\" data-id=\"b7b7409\" 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-d3e9418 elementor-widget elementor-widget-image\" data-id=\"d3e9418\" 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=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple21-1.jpg\" class=\"attachment-large size-large wp-image-159759\" alt=\"excel-mise-en-forme-conditionnelle-exemple(21)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple21-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple21-1-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-b995809 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b995809\" 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-340814f\" data-id=\"340814f\" 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-018e9b9 elementor-widget elementor-widget-text-editor\" data-id=\"018e9b9\" 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><span style=\"text-decoration: underline;\"><b><i>Cas pratique 2<\/i><\/b><\/span><\/p><p>Mise en surbrillance des week-ends et de la date du jour dans un planning<\/p><p>Cr\u00e9ons deux r\u00e8gles en cliquant sur <b>Nouvelle R\u00e8gle<\/b> puis <b>Utiliser une formule pour d\u00e9terminer pour quelles cellules le format sera appliqu\u00e9 <\/b>et dans la zone<b> Appliquer une mise en forme aux valeurs pour lesquelles cette formule est vraie,<\/b> saisir votre formule mais vous ne pouvez pas ins\u00e9rer automatiquement les fonctions, il faut les conna\u00eetre.<\/p><p>Cliquez une nouvelle fois sur <b>Nouvelle R\u00e8gle<\/b> ou bien dans <b>G\u00e9rer les r\u00e8gles<\/b> pour voir toutes les r\u00e8gles de votre s\u00e9lection<\/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-94230fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94230fe\" 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-cb007e7\" data-id=\"cb007e7\" 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-a1d2631 elementor-widget elementor-widget-image\" data-id=\"a1d2631\" 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=\"602\" height=\"347\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple22-1.jpg\" class=\"attachment-large size-large wp-image-159760\" alt=\"excel-mise-en-forme-conditionnelle-exemple(22)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple22-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple22-1-300x173.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-2f7d980 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f7d980\" 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-b9743bc\" data-id=\"b9743bc\" 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-430aab0 elementor-widget elementor-widget-text-editor\" data-id=\"430aab0\" 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>Voici les deux formules \u00e0 \u00e9crire :<\/p><p><strong>=F$10=AUJOURDHUI()<\/strong><\/p><p><strong>=OU(JOURSEM(F$10)=7;JOURSEM(F$10)=1)<\/strong><\/p><p>Mettez une r\u00e9f\u00e9rence mixte en figeant la ligne qui contient toutes les dates du mois et utilisons la fonction <b>Joursem <\/b>qui renvoie un num\u00e9ro de 1 \u00e0 7 du dimanche au samedi.<\/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-7e7785c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e7785c\" 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-5f89f42\" data-id=\"5f89f42\" 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-8f16f35 elementor-widget elementor-widget-image\" data-id=\"8f16f35\" 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=\"602\" height=\"216\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple23-1.jpg\" class=\"attachment-large size-large wp-image-159761\" alt=\"excel-mise-en-forme-conditionnelle-exemple(23)\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple23-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple23-1-300x108.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-36a2e51 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36a2e51\" 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-498a9f3\" data-id=\"498a9f3\" 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-345ac32 elementor-widget elementor-widget-text-editor\" data-id=\"345ac32\" 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>On peut revenir sur les formules en cliquant sur <b>G\u00e9rer les r\u00e8gles<\/b> et double cliquer sur la r\u00e8gle que l\u2019on veut modifier.<\/p><p>Voici le r\u00e9sultat obtenu :<\/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-a2c3452 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a2c3452\" 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-21ded2a\" data-id=\"21ded2a\" 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-7a0b39c elementor-widget elementor-widget-image\" data-id=\"7a0b39c\" 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=\"602\" height=\"121\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple24-1.jpg\" class=\"attachment-large size-large wp-image-159762\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple24-1.jpg 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-exemple24-1-300x60.jpg 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-01d7454 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01d7454\" 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-19177dd\" data-id=\"19177dd\" 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-e1faa3f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e1faa3f\" 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=\"\/formations-data\">\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\">D\u00e9couvrir nos formations en Data<\/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>La mise en forme conditionnelle permet de mettre en \u00e9vidence certaines valeurs ou de rendre des cellules faciles \u00e0 identifier. Elle modifie l&rsquo;apparence d&rsquo;une plage de cellules en fonction d&rsquo;une condition ou de plusieurs crit\u00e8res.\u00a0 Dans cet article, vous allez apprendre les astuces de la mise en forme conditionnelle et comprendre comment mettre en \u00e9vidence [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":159736,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>Mise en forme conditionnelle d&#039;un tableau Excel en fonction de ses valeurs<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez dans cet article les astuces de la mise en forme conditionnelle excel et comment mettre en \u00e9vidence les donn\u00e9es.\" \/>\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\/excel-mise-en-forme-conditionnelle\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment mettre en forme les donn\u00e9es d\u2019un tableau Excel en fonction de ses valeurs ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-01T09:27:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T16:08:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1520\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle\",\"url\":\"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle\",\"name\":\"Mise en forme conditionnelle d'un tableau Excel en fonction de ses valeurs\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-06-01T09:27:54+00:00\",\"dateModified\":\"2024-02-13T16:08:56+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"D\u00e9couvrez dans cet article les astuces de la mise en forme conditionnelle excel et comment mettre en \u00e9vidence les donn\u00e9es.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Mise en forme conditionnelle d'un tableau Excel en fonction de ses valeurs","description":"D\u00e9couvrez dans cet article les astuces de la mise en forme conditionnelle excel et comment mettre en \u00e9vidence les donn\u00e9es.","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\/excel-mise-en-forme-conditionnelle","og_locale":"fr_FR","og_type":"article","og_title":"Comment mettre en forme les donn\u00e9es d\u2019un tableau Excel en fonction de ses valeurs ?","og_url":"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-06-01T09:27:54+00:00","article_modified_time":"2024-02-13T16:08:56+00:00","og_image":[{"width":1520,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-mise-en-forme-conditionnelle-1.jpg","type":"image\/jpeg"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle","url":"https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle","name":"Mise en forme conditionnelle d'un tableau Excel en fonction de ses valeurs","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-06-01T09:27:54+00:00","dateModified":"2024-02-13T16:08:56+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"D\u00e9couvrez dans cet article les astuces de la mise en forme conditionnelle excel et comment mettre en \u00e9vidence les donn\u00e9es.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/excel-mise-en-forme-conditionnelle"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/159735"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=159735"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/159735\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/159736"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=159735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=159735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=159735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}