{"id":8052,"date":"2019-02-13T07:04:21","date_gmt":"2019-02-13T06:04:21","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8052"},"modified":"2019-02-11T00:30:10","modified_gmt":"2019-02-10T23:30:10","slug":"format-personnalise-dexcel-mettre-de-la-couleur-dans-ses-donnees","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8052","title":{"rendered":"Format personnalis\u00e9 d&#8217;Excel : mettre de la couleur dans ses donn\u00e9es"},"content":{"rendered":"<p style=\"text-align: justify;\">Les <a href=\"https:\/\/www.auditsi.eu\/?p=8013\">formats personnalis\u00e9s<\/a> permettent de d\u00e9finir un format sp\u00e9cifique en fonction de la nature des donn\u00e9es. La mise en forme concerne \u00e9galement la couleur.<a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8053\" rel=\"attachment wp-att-8053\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8053\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Couleurs-Excel.png\" alt=\"Codes couleur Excel\" width=\"356\" height=\"334\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Couleurs-Excel.png 356w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Couleurs-Excel-300x281.png 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Le format se param\u00e8tre ainsi :<\/p>\n<p style=\"text-align: center;\">[Vert]# ##0,00 \u20ac;[Rouge]-# ##0,00 \u20ac<\/p>\n<p>Les couleurs utilisables entre crochets sont les suivantes :<\/p>\n<p style=\"text-align: center;\">Noir, Bleu, Cyan, Magenta, Rouge, Blanc et Jaune.<\/p>\n<p style=\"text-align: justify;\">Si ces couleurs ne suffisent pas, il est possible d&#8217;en appeler 56 en tout \u00e0 l&#8217;aide de la commande [couleurxx] o\u00f9 xx repr\u00e9sente le num\u00e9ro de la couleur dans la palette.<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Format%20personnalis%C3%A9%20d%27Excel%20%3A%20mettre%20de%20la%20couleur%20dans%20ses%20donn%C3%A9es\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les formats personnalis\u00e9s permettent de d\u00e9finir un format sp\u00e9cifique en fonction de la nature des donn\u00e9es. La mise en forme concerne \u00e9galement la couleur. Le format se param\u00e8tre ainsi : [Vert]# ##0,00 \u20ac;[Rouge]-# ##0,00 \u20ac Les couleurs utilisables entre crochets sont les suivantes : Noir, Bleu, Cyan, Magenta, Rouge, Blanc et Jaune. Si ces couleurs &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8052\" class=\"more-link\">Continue reading &lsquo;Format personnalis\u00e9 d&#8217;Excel : mettre de la couleur dans ses donn\u00e9es&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Format%20personnalis%C3%A9%20d%27Excel%20%3A%20mettre%20de%20la%20couleur%20dans%20ses%20donn%C3%A9es\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48],"tags":[896,1633,2002,1999],"class_list":["post-8052","post","type-post","status-publish","format-standard","hentry","category-excel","tag-codes-couleur","tag-excel","tag-format-de-cellule","tag-format-personnalise"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8052"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8052\/revisions"}],"predecessor-version":[{"id":8059,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8052\/revisions\/8059"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}