{"id":171205,"date":"2023-03-22T17:33:00","date_gmt":"2023-03-22T16:33:00","guid":{"rendered":"https:\/\/datascientest.com\/de\/?p=171205"},"modified":"2023-10-29T20:33:41","modified_gmt":"2023-10-29T19:33:41","slug":"bedingte-formatierung-excel-so-gehts","status":"publish","type":"post","link":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts","title":{"rendered":"Bedingte Formatierung Excel: So geht&#8217;s!"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"171205\" class=\"elementor elementor-171205\" 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-dec4e61 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dec4e61\" 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-1a98a97e\" data-id=\"1a98a97e\" 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-1dae5706 elementor-widget elementor-widget-heading\" data-id=\"1dae5706\" 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\">Bedingte Formatierung Excel: Die bedingte Formatierung Excel erm\u00f6glicht es, bestimmte Werte hervorzuheben oder Zellen leicht erkennbar zu machen. Sie ver\u00e4ndert das Aussehen eines Bereichs von Zellen auf der Grundlage einer Bedingung oder mehrerer Kriterien.\u00a0\nIn diesem Artikel lernst du die Tricks der bedingten Formatierung kennen und verstehst, wie du die Daten, die du in deiner Analyse vorziehen m\u00f6chtest, hervorheben kannst.\u00a0\u00a0<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-268f946e elementor-widget elementor-widget-text-editor\" data-id=\"268f946e\" 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>Wir werden die folgende Tabelle im Laufe des Artikels verwenden, um die verschiedenen Funktionen der <strong>bedingten Formatierung in <a href=\"https:\/\/datascientest.com\/de\/zur-excel-zeile-gehen\">Excel<\/a><\/strong> zu veranschaulichen. Die Tabelle zeigt den Preis verschiedener Pflanzensorten in Abh\u00e4ngigkeit vom Datum, an dem sie verkauft werden.\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-3b6c4b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b6c4b7\" 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-d246ba3\" data-id=\"d246ba3\" 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-40f1572e elementor-widget elementor-widget-image\" data-id=\"40f1572e\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple1.jpg\" class=\"attachment-large size-large wp-image-171208\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple1.jpg 464w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-7bb5e9c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7bb5e9c8\" 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-5331b297\" data-id=\"5331b297\" 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-580816cf elementor-widget elementor-widget-heading\" data-id=\"580816cf\" 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\/ Bedingte Formatierung mithilfe der Multifunktionsleiste von 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-5d65b04 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d65b04\" 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-4601aad0\" data-id=\"4601aad0\" 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-5ac269be elementor-widget elementor-widget-text-editor\" data-id=\"5ac269be\" 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>W\u00e4hle zun\u00e4chst den Bereich der Betr\u00e4ge aus und klicke dann auf der Registerkarte Start auf<strong> Bedingte Formatierung.<\/strong><\/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-33cef7a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"33cef7a8\" 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-61ba7818\" data-id=\"61ba7818\" 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-22495438 elementor-widget elementor-widget-image\" data-id=\"22495438\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple2.jpg\" class=\"attachment-large size-large wp-image-171209\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple2.jpg 284w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-3d8d5884 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d8d5884\" 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-12cdd7a9\" data-id=\"12cdd7a9\" 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-51da5cde elementor-widget elementor-widget-text-editor\" data-id=\"51da5cde\" 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>Wenn Du Regeln f\u00fcr die <strong>Hervorhebung von Zellen<\/strong> ausw\u00e4hlst, stehen Dir mehrere Optionen zur Verf\u00fcgung. Du kannst Betr\u00e4ge hervorheben, die gr\u00f6\u00dfer oder kleiner als ein bestimmter Betrag sind, zwischen zwei Betr\u00e4gen liegen, gleich einem bestimmten Betrag sind&#8230; und sogar deine eigenen Regeln \u00fcber das Men\u00fc &#8222;Weitere Regeln&#8230;&#8220; zusammenstellen.<\/li><\/ul><div class=\"notranslate\" style=\"all: initial;\">\u00a0<\/div>\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-350832db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"350832db\" 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-7efea7a7\" data-id=\"7efea7a7\" 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-5381bb90 elementor-widget elementor-widget-image\" data-id=\"5381bb90\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple3-1.jpg\" class=\"attachment-large size-large wp-image-171210\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple3-1.jpg 422w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-a287d1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a287d1b\" 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-4036c81c\" data-id=\"4036c81c\" 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-68a625a7 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"68a625a7\" 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\/de\/unsere-aus-und-weiterbildungen\">\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\">Excel Kurs<\/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-f3bce54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3bce54\" 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-42a1ef08\" data-id=\"42a1ef08\" 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-28fc04fe elementor-widget elementor-widget-text-editor\" data-id=\"28fc04fe\" 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>Beispiel 1<\/strong><\/span><\/p><p>Wenn Du &#8222;weniger als&#8220; ausw\u00e4hlst, kannst Du einen H\u00f6chstbetrag (z. B. 10) eingeben, unter dem die Werte wie folgt hervorgehoben werden: Alle Pflanzen, die weniger als 10 \u20ac kosten, werden in dem von dir gew\u00e4hlten benutzerdefinierten Format hervorgehoben. In diesem Fall werden die Zellen, die dieses Kriterium erf\u00fcllen, blau mit roter Schrift hervorgehoben.<\/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-64e7db07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64e7db07\" 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-1ee9b4d6\" data-id=\"1ee9b4d6\" 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-2fb6eeb3 elementor-widget elementor-widget-image\" data-id=\"2fb6eeb3\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple4.jpg\" class=\"attachment-large size-large wp-image-171211\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple4.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-5ebfbfba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ebfbfba\" 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-6ae5def6\" data-id=\"6ae5def6\" 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-428ed7d elementor-widget elementor-widget-image\" data-id=\"428ed7d\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple5.jpg\" class=\"attachment-large size-large wp-image-171212\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple5.jpg 526w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-29dd1c22 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"29dd1c22\" 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-7667ce0\" data-id=\"7667ce0\" 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-75e30da elementor-widget elementor-widget-text-editor\" data-id=\"75e30da\" 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>Beispiel 2<\/strong><\/p><p>Du kannst auch alle Zellen hervorheben, die einen bestimmten Text oder Daten enthalten, die gestern, heute, morgen, in den letzten 7 Tagen, in der letzten Woche, in dieser Woche, in der n\u00e4chsten Woche, im letzten Monat, in diesem Monat oder im n\u00e4chsten Monat vorkommen.<\/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-3baf68b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3baf68b0\" 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-29dfb165\" data-id=\"29dfb165\" 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-366e2293 elementor-widget elementor-widget-image\" data-id=\"366e2293\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple6.jpg\" class=\"attachment-large size-large wp-image-171213\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple6.jpg 564w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-7f7c5876 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f7c5876\" 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-4f1b85c2\" data-id=\"4f1b85c2\" 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-3f2a7a54 elementor-widget elementor-widget-text-editor\" data-id=\"3f2a7a54\" 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>Du kannst auch Regel f\u00fcr hohe\/niedrige Bereichswerte w\u00e4hlen. Wenn du die 5 h\u00f6chsten Werte rot markieren willst, musst du &#8222;10 h\u00f6chste Werte&#8220; ausw\u00e4hlen und dann im Dialogfeld 10 durch 5 ersetzen. Du kannst dann das Format \u00e4ndern, in dem die Werte angezeigt werden sollen (z. B.: hellrote F\u00fcllung mit dunkelrotem 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-38503906 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38503906\" 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-3bc0e8f1\" data-id=\"3bc0e8f1\" 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-46baa427 elementor-widget elementor-widget-image\" data-id=\"46baa427\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple7.jpg\" class=\"attachment-large size-large wp-image-171214\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple7.jpg 584w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-1c0681ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c0681ea\" 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-4b8c43f9\" data-id=\"4b8c43f9\" 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-a523404 elementor-widget elementor-widget-image\" data-id=\"a523404\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple8.jpg\" class=\"attachment-large size-large wp-image-171215\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple8.jpg 572w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-771b984d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"771b984d\" 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-3bf215e8\" data-id=\"3bf215e8\" 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-146302c0 elementor-widget elementor-widget-text-editor\" data-id=\"146302c0\" 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>Du erh\u00e4ltst Folgendes:<\/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-57b414d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"57b414d1\" 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-2aeb939b\" data-id=\"2aeb939b\" 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-2ad3dd46 elementor-widget elementor-widget-image\" data-id=\"2ad3dd46\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple9.jpg\" class=\"attachment-large size-large wp-image-171216\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple9.jpg 379w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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\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-6fa5d18d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fa5d18d\" 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-3d8beb5e\" data-id=\"3d8beb5e\" 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-f68501c elementor-widget elementor-widget-text-editor\" data-id=\"f68501c\" 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>Du kannst auch Datenbalken, Farbschattierungen oder Symbols\u00e4tze w\u00e4hlen.<\/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-76487ab7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"76487ab7\" 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-1ab41a43\" data-id=\"1ab41a43\" 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-62a6bce9 elementor-widget elementor-widget-text-editor\" data-id=\"62a6bce9\" 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>Beispiel mit Icon-Set<\/strong><\/p><p>W\u00e4hle 3, 4 oder 5 Icons, je nachdem, wie viele Scheiben du haben m\u00f6chtest.<\/p><div class=\"notranslate\" style=\"all: initial;\">\u00a0<\/div>\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-6a6471fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a6471fd\" 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-4a23844a\" data-id=\"4a23844a\" 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-1e4a7f59 elementor-widget elementor-widget-image\" data-id=\"1e4a7f59\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple10.jpg\" class=\"attachment-large size-large wp-image-171217\" 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-3c4cd16f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c4cd16f\" 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-5ef231d4\" data-id=\"5ef231d4\" 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-3f77778b elementor-widget elementor-widget-image\" data-id=\"3f77778b\" 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=\"223\" src=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple11.jpg\" class=\"attachment-large size-large wp-image-171218\" 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-37f366dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37f366dc\" 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-506aed2b\" data-id=\"506aed2b\" 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-50dfd47d elementor-widget elementor-widget-text-editor\" data-id=\"50dfd47d\" 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>Um diese Regeln nach deinen W\u00fcnschen zu \u00e4ndern, klicke auf Start \/ Bedingte Formatierung \/ Regeln verwalten.<\/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-1f6d55b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f6d55b3\" 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-93876e4\" data-id=\"93876e4\" 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-6e80c441 elementor-widget elementor-widget-image\" data-id=\"6e80c441\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple12.jpg\" class=\"attachment-large size-large wp-image-171219\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple12.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-572a7093 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"572a7093\" 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-119cf156\" data-id=\"119cf156\" 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-78124a37 elementor-widget elementor-widget-text-editor\" data-id=\"78124a37\" 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>Und mit einem Doppelklick auf die Regel Icon-Set erh\u00e4lt man :<\/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-cbcfd8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbcfd8e\" 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-2db3b2c6\" data-id=\"2db3b2c6\" 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-285a4dfc elementor-widget elementor-widget-image\" data-id=\"285a4dfc\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple13.jpg\" class=\"attachment-large size-large wp-image-171220\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple13.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-147bdcf elementor-widget elementor-widget-text-editor\" data-id=\"147bdcf\" 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>(Nach Belieben zu \u00e4ndern)<\/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-689aedb9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"689aedb9\" 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-ce82548\" data-id=\"ce82548\" 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-18e3efec elementor-widget elementor-widget-text-editor\" data-id=\"18e3efec\" 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>Wenn du mehrere <strong>Regeln f\u00fcr einen Zellbereich<\/strong> definiert hast und das H\u00e4kchen Abbrechen, wenn wahr gesetzt hast, werden die folgenden Regeln nicht mehr angewendet, wenn die erste Regel wahr ist.<\/p><p>Achtung: Wenn du Zellen kopierst\/einf\u00fcgst, wird auch die bedingte Formatierung kopiert.<\/p><p>Versuche mal, unter Start \/ Bedingte Formatierung auf Regeln verwalten zu gehen, um eine Regel zu erstellen, zu \u00e4ndern oder zu l\u00f6schen. Schau dir die <strong>Zellbereiche,<\/strong> auf die diese Regeln angewendet werden, genau an.\u00a0<\/p><p>Da du den Zellbereich vor dem \u00c4ndern der Regeln ausw\u00e4hlen musst, w\u00e4re es sinnvoll, den Bereich in der<strong> Multifunktionsleiste Formeln \/ Namen<\/strong> festlegen zu benennen, damit du dich wiederfinden kannst, wenn dein Excel-Blatt viele Daten enth\u00e4lt.\u00a0\u00a0<\/p><div class=\"notranslate\" style=\"all: initial;\">\u00a0<\/div>\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-4b642bfa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b642bfa\" 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-37f8f9fe\" data-id=\"37f8f9fe\" 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-480d53c5 elementor-widget elementor-widget-image\" data-id=\"480d53c5\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple14.jpg\" class=\"attachment-large size-large wp-image-171221\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple14.jpg 454w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-469c4b23 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"469c4b23\" 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-5dcbd5bb\" data-id=\"5dcbd5bb\" 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-3d40bdb6 elementor-widget elementor-widget-text-editor\" data-id=\"3d40bdb6\" 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>Und dann w\u00e4hlst Du einfach den Namen aus der Dropdown-Liste links neben der Formelleiste aus, bevor du die Regeln f\u00fcr die bedingte Formatierung \u00e4nderst.<\/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-2f0536e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f0536e6\" 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-626b7ad4\" data-id=\"626b7ad4\" 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-201a1a6d elementor-widget elementor-widget-image\" data-id=\"201a1a6d\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple15.jpg\" class=\"attachment-large size-large wp-image-171222\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple15.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-1d004a55 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d004a55\" 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-7c22962\" data-id=\"7c22962\" 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-26c14730 elementor-widget elementor-widget-text-editor\" data-id=\"26c14730\" 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>Man kann auch die Priorit\u00e4t der Regeln mit den Pfeilen \u00e4ndern.<\/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-1c385cac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c385cac\" 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-43edf98d\" data-id=\"43edf98d\" 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-3fe1ef68 elementor-widget elementor-widget-heading\" data-id=\"3fe1ef68\" 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\/ Eine ganze Zeile formatieren<\/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-731176a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"731176a7\" 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-628e6bff\" data-id=\"628e6bff\" 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-10b05540 elementor-widget elementor-widget-text-editor\" data-id=\"10b05540\" 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>Noch interessanter! Excel erlaubt es auch, eine ganze Zeile und nicht nur eine Spalte farbig zu markieren, je nach dem Wert einer Spalte :<\/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-21785eed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21785eed\" 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-3cd4023e\" data-id=\"3cd4023e\" 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-35c8b4b1 elementor-widget elementor-widget-image\" data-id=\"35c8b4b1\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple16.jpg\" class=\"attachment-large size-large wp-image-171223\" 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-44e0fe00 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44e0fe00\" 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-2e396f81\" data-id=\"2e396f81\" 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-3eb86246 elementor-widget elementor-widget-image\" data-id=\"3eb86246\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple17.jpg\" class=\"attachment-large size-large wp-image-171224\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple17.jpg 263w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-39d0adb0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"39d0adb0\" 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-319b2e42\" data-id=\"319b2e42\" 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-2f99f088 elementor-widget elementor-widget-text-editor\" data-id=\"2f99f088\" 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>Um die Tabelle auf der linken Seite zu erhalten, musst du den Zellbereich ausw\u00e4hlen, der der Spalte Pflanze entspricht. Klicke dann auf die Registerkarte Start \/ Bedingte Formatierung und w\u00e4hle den Regeltyp: Formatierung nur auf Zellen anwenden, die enthalten.<\/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-6a9eb9fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a9eb9fc\" 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-1344172c\" data-id=\"1344172c\" 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-4cf37dc5 elementor-widget elementor-widget-image\" data-id=\"4cf37dc5\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple18.jpg\" class=\"attachment-large size-large wp-image-171225\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple18.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-7d5e9677 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d5e9677\" 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-4f417895\" data-id=\"4f417895\" 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-24458138 elementor-widget elementor-widget-text-editor\" data-id=\"24458138\" 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>Um die Tabelle auf der rechten Seite zu erhalten, musst du die gesamte Tabelle ausw\u00e4hlen und eine Formel mit einem gemischten Bezug verwenden: Spalte fixieren, aber nicht die Zeile, d. h. einen Dollar vor die Spalte und nichts vor die Zeile setzen oder dreimal die Taste F4 oder Fn F4 dr\u00fccken:<\/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-3ba24ae1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3ba24ae1\" 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-18379f48\" data-id=\"18379f48\" 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-5ee13c27 elementor-widget elementor-widget-image\" data-id=\"5ee13c27\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple19.jpg\" class=\"attachment-large size-large wp-image-171226\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple19.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-3e8811e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e8811e6\" 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-7d557375\" data-id=\"7d557375\" 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-7b1ec8bf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7b1ec8bf\" 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\/de\/unsere-aus-und-weiterbildungen\">\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\">Excel Schulung<\/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-3f263b0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3f263b0c\" 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-43add9a4\" data-id=\"43add9a4\" 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-3a688227 elementor-widget elementor-widget-heading\" data-id=\"3a688227\" 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\/ Einf\u00fcgen von Funktionen in die bedingte Formatierung<\/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-38cbef09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38cbef09\" 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-516e49ec\" data-id=\"516e49ec\" 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-5fd4fd97 elementor-widget elementor-widget-text-editor\" data-id=\"5fd4fd97\" 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>Du kannst auch alle Excel-Funktionen in die bedingte Formatierung einf\u00fcgen, wenn du dich entscheidest, eine Formel zu verwenden, um zu bestimmen, f\u00fcr welche <strong>Zellen das Format angewendet wird.<\/strong><\/p><div class=\"notranslate\" style=\"all: initial;\">\u00a0<\/div>\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-1d4fd4b6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d4fd4b6\" 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-6f648cc4\" data-id=\"6f648cc4\" 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-11d8db94 elementor-widget elementor-widget-image\" data-id=\"11d8db94\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple20.jpg\" class=\"attachment-large size-large wp-image-171227\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple20.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-7d943a15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d943a15\" 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-69695da7\" data-id=\"69695da7\" 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-5501bf76 elementor-widget elementor-widget-text-editor\" data-id=\"5501bf76\" 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>Fallbeispiel 1<\/strong><\/p><p>Stelle in einem Zeitplan die Anfangs- und Enddaten des Verkaufs von Pflanzen wie oben dargestellt dar. Fixiere die Spalte f\u00fcr das Start- und Enddatum und die Zeile f\u00fcr das Monatsdatum mit gemischten Bez\u00fcgen und verwende die UND-Funktion.<\/p><p>Du musst den<strong> karierten Zellbereich<\/strong> der Tabelle ausw\u00e4hlen und \u00fcber Start\/ Bedingte Formatierung \/ Formel verwenden bestimmen, f\u00fcr welche Zellen das Format angewendet werden soll:<\/p><p>Schreibe die Formel: =ET(F$3&gt;=$A4;F$3&lt;=$B4) und klicke dann auf die Schaltfl\u00e4che Format&#8230; und die Registerkarte F\u00fcllung.<\/p><div class=\"notranslate\" style=\"all: initial;\">\u00a0<\/div>\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-a8ce01b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a8ce01b\" 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-2b5c2b38\" data-id=\"2b5c2b38\" 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-4dfa24cf elementor-widget elementor-widget-image\" data-id=\"4dfa24cf\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple21.jpg\" class=\"attachment-large size-large wp-image-171228\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple21.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-7aa588cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7aa588cd\" 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-6c9cdcb5\" data-id=\"6c9cdcb5\" 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-2c5007cb elementor-widget elementor-widget-text-editor\" data-id=\"2c5007cb\" 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>Fallbeispiel 2<\/p><p><strong>Hervorhebung von Wochenenden<\/strong> und des aktuellen Datums in einem Zeitplan.<\/p><p>Wir erstellen zwei Regeln, indem wir auf Neue Regel klicken und dann Formel verwenden, um festzulegen, f\u00fcr welche Zellen das Format angewendet werden soll, und im Feld Formatierung auf Werte anwenden, f\u00fcr die diese Formel zutrifft deine Formel eingeben, aber du kannst die Funktionen nicht automatisch einf\u00fcgen, du musst sie kennen.<\/p><p>Klicke noch einmal auf Neue Regel oder auf Regeln verwalten, um alle Regeln in deiner Auswahl zu sehen.<\/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-4de1170a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4de1170a\" 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-3c307e4f\" data-id=\"3c307e4f\" 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-7177270c elementor-widget elementor-widget-image\" data-id=\"7177270c\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple22.jpg\" class=\"attachment-large size-large wp-image-171229\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple22.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-198024f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"198024f6\" 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-1578c4ac\" data-id=\"1578c4ac\" 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-69e735 elementor-widget elementor-widget-text-editor\" data-id=\"69e735\" 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>Hier sind die beiden Formeln, die du eingeben musst:<\/p><p>=F$10=HEUTE()<\/p><p>=ODER(TAGSEM(F$10)=7;TAGSEM(F$10)=1)<\/p><p>Setze einen gemischten Verweis, indem du die Zeile einfrierst, die alle Daten des Monats enth\u00e4lt, und verwende die Funktion Joursem, die eine Zahl von 1 bis 7 von Sonntag bis Samstag zur\u00fcckgibt.<\/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-52b1fb4a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"52b1fb4a\" 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-7d9f8600\" data-id=\"7d9f8600\" 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-218f8e1a elementor-widget elementor-widget-image\" data-id=\"218f8e1a\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple23.jpg\" class=\"attachment-large size-large wp-image-171230\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple23.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-723a84d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"723a84d3\" 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-43100cf\" data-id=\"43100cf\" 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-5ddd80bd elementor-widget elementor-widget-text-editor\" data-id=\"5ddd80bd\" 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>Man kann zu den Formeln zur\u00fcckkehren, indem man auf Regeln verwalten klickt und auf die Regel, die man \u00e4ndern m\u00f6chte, doppelklickt.<\/p><p>Hier ist das Ergebnis:<\/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-5893a5a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5893a5a3\" 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-391e6bab\" data-id=\"391e6bab\" 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-28791da3 elementor-widget elementor-widget-image\" data-id=\"28791da3\" 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\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple24.jpg\" class=\"attachment-large size-large wp-image-171231\" alt=\"\" srcset=\"https:\/\/datascientest.com\/de\/files\/2023\/03\/excel-mise-en-forme-conditionnelle-exemple24.jpg 602w, https:\/\/datascientest.com\/de\/files\/2023\/03\/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-5c2ec625 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c2ec625\" 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-1e1cc65f\" data-id=\"1e1cc65f\" 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-5c3a39a8 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5c3a39a8\" 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\/de\/unsere-aus-und-weiterbildungen\">\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\">Mehr \u00fcber die Excel-Schulung<\/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>Bedingte Formatierung Excel: Die bedingte Formatierung Excel erm\u00f6glicht es, bestimmte Werte hervorzuheben oder Zellen leicht erkennbar zu machen. Sie ver\u00e4ndert das Aussehen eines Bereichs von Zellen auf der Grundlage einer Bedingung oder mehrerer Kriterien. In diesem Artikel lernst du die Tricks der bedingten Formatierung kennen und verstehst, wie du die Daten, die du in deiner [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":171206,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2461],"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>Bedingte Formatierung Excel: So geht&#039;s!<\/title>\n<meta name=\"description\" content=\"Die Bedingte Formatierung Excel ist ein n\u00fctzliches Tool fur Deine Datenverarbeitung. Wir zeigen Dir, wie es geht!\" \/>\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\/de\/bedingte-formatierung-excel-so-gehts\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bedingte Formatierung Excel: So geht&#039;s!\" \/>\n<meta property=\"og:description\" content=\"Bedingte Formatierung Excel: Die bedingte Formatierung Excel erm\u00f6glicht es, bestimmte Werte hervorzuheben oder Zellen leicht erkennbar zu machen. Sie\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\" \/>\n<meta property=\"og:site_name\" content=\"Weiterbildung Data Science | DataScientest.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-22T16:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-29T19:33:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/03\/bedingte-formatierung.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"404\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Daniel\" \/>\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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\"},\"author\":{\"name\":\"Daniel\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\"},\"headline\":\"Bedingte Formatierung Excel: So geht&#8217;s!\",\"datePublished\":\"2023-03-22T16:33:00+00:00\",\"dateModified\":\"2023-10-29T19:33:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\"},\"wordCount\":978,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\",\"url\":\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\",\"name\":\"Bedingte Formatierung Excel: So geht's!\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/#website\"},\"datePublished\":\"2023-03-22T16:33:00+00:00\",\"dateModified\":\"2023-10-29T19:33:41+00:00\",\"description\":\"Die Bedingte Formatierung Excel ist ein n\u00fctzliches Tool fur Deine Datenverarbeitung. Wir zeigen Dir, wie es geht!\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/de\/#website\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"name\":\"Weiterbildung Data Science | DataScientest.com\",\"description\":\"F\u00fchrender Anbieter von Schulungen im Bereich Data Science\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/de\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/company\/datascientest-germany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0\",\"name\":\"Daniel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g\",\"caption\":\"Daniel\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/school\/datascientest\/\",\"user\"],\"jobTitle\":\"ing\u00e9nieur logiciel\",\"worksFor\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/de\/author\/team-redac\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Bedingte Formatierung Excel: So geht's!","description":"Die Bedingte Formatierung Excel ist ein n\u00fctzliches Tool fur Deine Datenverarbeitung. Wir zeigen Dir, wie es geht!","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\/de\/bedingte-formatierung-excel-so-gehts","og_locale":"de_DE","og_type":"article","og_title":"Bedingte Formatierung Excel: So geht's!","og_description":"Bedingte Formatierung Excel: Die bedingte Formatierung Excel erm\u00f6glicht es, bestimmte Werte hervorzuheben oder Zellen leicht erkennbar zu machen. Sie","og_url":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts","og_site_name":"Weiterbildung Data Science | DataScientest.com","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-03-22T16:33:00+00:00","article_modified_time":"2023-10-29T19:33:41+00:00","og_image":[{"width":1024,"height":404,"url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/03\/bedingte-formatierung.webp","type":"image\/webp"}],"author":"Daniel","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Verfasst von":"Daniel","Gesch\u00e4tzte Lesezeit":"10 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts#article","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts"},"author":{"name":"Daniel","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0"},"headline":"Bedingte Formatierung Excel: So geht&#8217;s!","datePublished":"2023-03-22T16:33:00+00:00","dateModified":"2023-10-29T19:33:41+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts"},"wordCount":978,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts","url":"https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts","name":"Bedingte Formatierung Excel: So geht's!","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/#website"},"datePublished":"2023-03-22T16:33:00+00:00","dateModified":"2023-10-29T19:33:41+00:00","description":"Die Bedingte Formatierung Excel ist ein n\u00fctzliches Tool fur Deine Datenverarbeitung. Wir zeigen Dir, wie es geht!","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/de\/bedingte-formatierung-excel-so-gehts"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/de\/#website","url":"https:\/\/datascientest.com\/de\/","name":"Weiterbildung Data Science | DataScientest.com","description":"F\u00fchrender Anbieter von Schulungen im Bereich Data Science","publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/de\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/company\/datascientest-germany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/5a86e30c5090234fb43dd8baa83c44b0","name":"Daniel","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/837acad4f2dc47e85d81cce837261670?s=96&d=mm&r=g","caption":"Daniel"},"sameAs":["https:\/\/www.linkedin.com\/school\/datascientest\/","user"],"jobTitle":"ing\u00e9nieur logiciel","worksFor":"DataScientest","url":"https:\/\/datascientest.com\/de\/author\/team-redac"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/171205"}],"collection":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/comments?post=171205"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/171205\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media\/171206"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media?parent=171205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/categories?post=171205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/tags?post=171205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}