{"id":315,"date":"2023-11-04T19:19:59","date_gmt":"2023-11-04T19:19:59","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/formulas-1\/"},"modified":"2023-12-06T11:33:33","modified_gmt":"2023-12-06T11:33:33","slug":"formulas-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/formulas-1\/","title":{"rendered":"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no excel"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1375757392\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-2569904715\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>A melhor parte da formata\u00e7\u00e3o condicional \u00e9 que voc\u00ea pode usar f\u00f3rmulas nela. E tem um sentido muito simples de trabalhar com f\u00f3rmulas.<\/p><p> Sua f\u00f3rmula deve ser l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Se a f\u00f3rmula retornar TRUE, voc\u00ea obter\u00e1 a formata\u00e7\u00e3o e, se FALSE, nada. O fato \u00e9 que usando f\u00f3rmulas voc\u00ea pode aproveitar ao m\u00e1ximo a formata\u00e7\u00e3o condicional.<\/p><p> Sim, \u00e9 verdade. No exemplo abaixo, usamos uma f\u00f3rmula em CF para verificar se o valor da c\u00e9lula \u00e9 menor que 1000 ou n\u00e3o. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\" sizes=\"\" srcset=\"\" alt=\"use f\u00f3rmulas em formata\u00e7\u00e3o condicional para verificar se o valor \u00e9 maior\"><\/figure><\/div><p> E se este valor for menor que 1000 aplicar\u00e1 a formata\u00e7\u00e3o que especificamos, caso contr\u00e1rio n\u00e3o. Ent\u00e3o, hoje neste artigo, gostaria de compartilhar com voc\u00eas etapas simples para aplicar a formata\u00e7\u00e3o condicional usando uma f\u00f3rmula. E alguns exemplos \u00fateis que voc\u00ea pode usar no seu trabalho di\u00e1rio.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Etapas para aplicar formata\u00e7\u00e3o condicional com f\u00f3rmulas<\/h2><p> Os passos para aplicar CF com f\u00f3rmulas s\u00e3o bastante simples:<\/p><ol><li> Selecione o intervalo para aplicar a formata\u00e7\u00e3o condicional.<\/li><li> Adicione uma f\u00f3rmula ao texto de uma condi\u00e7\u00e3o.<\/li><li> Especifique um formato a ser aplicado quando a condi\u00e7\u00e3o for atendida. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-appliquer-une-mise-en-forme-conditionnelle-a-laide-dune-formule-1.png\" sizes=\"\" srcset=\"\" alt=\"como aplicar formata\u00e7\u00e3o condicional usando uma f\u00f3rmula\"><\/figure><\/div><p> Para aprender isso corretamente, <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mise-en-forme-conditionnelle-avec-fichier-de-donnees-de-formules.xlsx\" rel=\"nofollow\">baixe este arquivo de amostra aqui<\/a> e siga as etapas detalhadas abaixo.<\/p><ul><li> Primeiro, selecione o intervalo onde deseja aplicar a formata\u00e7\u00e3o condicional. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-selectionner-une-plage-1.png\" sizes=\"\" srcset=\"\" alt=\"Para aplicar formata\u00e7\u00e3o condicional usando f\u00f3rmulas, selecione um intervalo\"><\/figure><\/div><ul><li> Depois disso, v\u00e1 para a guia In\u00edcio \u279c Estilos \u279c Formata\u00e7\u00e3o Condicional \u279c Nova Regra \u279c Use uma f\u00f3rmula para determinar qual c\u00e9lula formatar. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-cliquez-sur-nouvelle-regle-1.png\" sizes=\"\" srcset=\"\" alt=\"Para aplicar formata\u00e7\u00e3o condicional usando f\u00f3rmulas, clique em Nova regra\"><\/figure><\/div><ul><li> Agora, em \u201c <strong><span style=\"color: #000000;\">Formato de valores onde a f\u00f3rmula \u00e9 verdadeira<\/span><\/strong> \u201d, insira a f\u00f3rmula abaixo.<\/li><\/ul><p> =E5&lt;1000 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-entrez-la-formule-1.png\" sizes=\"\" srcset=\"\" alt=\"Para aplicar formata\u00e7\u00e3o condicional usando f\u00f3rmulas, insira uma f\u00f3rmula\"><\/figure><\/div><ul><li> O pr\u00f3ximo passo \u00e9 especificar o formato a aplicar e para isso clicar no bot\u00e3o formato e selecionar o formato. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pour-appliquer-une-mise-en-forme-conditionnelle-a-laide-de-formules-specifier-la-mise-en-forme-1.png\" sizes=\"\" srcset=\"\" alt=\"para aplicar formata\u00e7\u00e3o condicional usando f\u00f3rmulas especifique a formata\u00e7\u00e3o\"><\/figure><\/div><ul><li> No final, clique em OK.<\/li><\/ul><p> Ao inserir uma f\u00f3rmula na caixa de di\u00e1logo CF, voc\u00ea n\u00e3o pode ver seu resultado ou se essa f\u00f3rmula \u00e9 v\u00e1lida ou n\u00e3o. Portanto, a melhor pr\u00e1tica \u00e9 verificar esta f\u00f3rmula antes de us\u00e1-la no CF, inserindo-a em uma c\u00e9lula.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> 1. Use uma f\u00f3rmula baseada em outra c\u00e9lula<\/h2><p> Sim, voc\u00ea pode aplicar formata\u00e7\u00e3o condicional com base no valor de outra c\u00e9lula. Se voc\u00ea observar o exemplo abaixo, adicionamos uma f\u00f3rmula simples baseada em outra c\u00e9lula. E se o valor dessa c\u00e9lula vinculada atender \u00e0 condi\u00e7\u00e3o especificada, voc\u00ea obter\u00e1 formata\u00e7\u00e3o condicional. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-avec-une-formule-en-utilisant-une-autre-cellule-2-1.png\" sizes=\"\" srcset=\"\" alt=\"aplicar formata\u00e7\u00e3o condicional com uma f\u00f3rmula usando outra c\u00e9lula\"><\/figure><\/div><p> Quando a aprova\u00e7\u00e3o for inferior a 75%, ser\u00e1 destacada em vermelho. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-une-mise-en-forme-conditionnelle-avec-une-formule-en-utilisant-une-autre-cellule-avec-un-pourcentage-75-1.png\" sizes=\"\" srcset=\"\" alt=\"aplicar formata\u00e7\u00e3o condicional com uma f\u00f3rmula usando outra c\u00e9lula com porcentagem 75\"><\/figure><\/div><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 2. Formata\u00e7\u00e3o Condicional com IF<\/h2><p> Sempre que penso em condi\u00e7\u00f5es, a primeira coisa que me vem \u00e0 mente \u00e9 usar a fun\u00e7\u00e3o SE. E a melhor parte dessa fun\u00e7\u00e3o \u00e9 que ela se encaixa perfeitamente na formata\u00e7\u00e3o condicional. Deixe-me mostrar-lhe um exemplo: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-pour-appliquer-une-mise-en-forme-conditionnelle-avec-if-1.png\" sizes=\"\" srcset=\"\" alt=\"use f\u00f3rmulas para aplicar formata\u00e7\u00e3o condicional com if\"><\/figure><\/div><p> Aqui usamos IF para criar uma condi\u00e7\u00e3o e a condi\u00e7\u00e3o \u00e9 quando o n\u00famero de \u201cConclu\u00eddo\u201d no intervalo B3:B9 for igual ao n\u00famero de tarefas no intervalo A3:A9, ent\u00e3o o status final aparecer\u00e1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cette-formule-en-formatage-conditionnel-formatera-la-cellule-lorsque-toutes-les-taches-seront-terminees-1.gif\" sizes=\"\" srcset=\"\" alt=\"esta f\u00f3rmula em formata\u00e7\u00e3o condicional ir\u00e1 formatar a c\u00e9lula quando todas as tarefas forem conclu\u00eddas\"><\/figure><\/div><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> 3. Formata\u00e7\u00e3o condicional com m\u00faltiplas condi\u00e7\u00f5es<\/h2><p> Voc\u00ea pode criar diversas condi\u00e7\u00f5es de verifica\u00e7\u00e3o para aplicar ao formato. Assim que todas ou alguma das condi\u00e7\u00f5es forem atendidas, a formata\u00e7\u00e3o condicional ser\u00e1 aplicada \u00e0 c\u00e9lula. Veja o exemplo abaixo onde usamos a temperatura m\u00e9dia da minha cidade.<\/p><p> E usamos um SI-AND combinado de forma simples para destacar os meses em que a temperatura est\u00e1 bastante agrad\u00e1vel. Os meses onde a temperatura estiver entre 15 Celsius e 35 Celsius ser\u00e3o coloridos. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-si-et-formule-dans-la-mise-en-forme-conditionnelle-pour-mettre-en-surbrillance-la-cellule-avec-des-tempratures-1.gif\" sizes=\"\" srcset=\"\" alt=\"use if e f\u00f3rmula em formata\u00e7\u00e3o condicional para destacar c\u00e9lulas com temperaturas\"><\/figure><\/div><p> Da mesma forma, voc\u00ea tamb\u00e9m pode usar <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/pt\/se-ou-1\/\">if with ou function<\/a> .<\/p><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> 4. Destaque linhas alternativas com formata\u00e7\u00e3o condicional<\/h2><p> Para destacar cada linha alternativa, voc\u00ea pode usar a seguinte f\u00f3rmula nCF.<\/p><p class=\"formula\"> =INT(MOD(LINHA(),2))<\/p><p> Usando esta f\u00f3rmula, cada linha com um n\u00famero \u00edmpar ser\u00e1 destacada. E, se quiser fazer o contr\u00e1rio, voc\u00ea pode usar a seguinte f\u00f3rmula. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-avec-des-lignes-alternatives-en-surbrillance-utilisant-une-formule-dans-une-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"tabela com linhas alternativas destacadas usando uma f\u00f3rmula em formata\u00e7\u00e3o condicional\"><\/figure><\/div><p class=\"formula\"> =INT(MOD(LINHA()+1,2))<\/p><p> O mesmo tipo de f\u00f3rmula tamb\u00e9m pode ser usado para colunas (\u00edmpares e pares).<\/p><p class=\"formula\"> =INT(MOD(COLUNA(),2))<\/p><p> E para colunas pares.<\/p><p class=\"formula\"> =INT(MOD(COLUNA()+1,2)) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-mise-en-forme-conditionnelle-mettre-en-surbrillance-la-colonne-alternative-1.gif\" sizes=\"\" srcset=\"\" alt=\"usar formata\u00e7\u00e3o condicional destacar coluna alternativa\"><\/figure><\/div><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> 5. Destaque c\u00e9lulas com erros usando CF<\/h2><p> Agora vamos para outro exemplo onde verificaremos se uma c\u00e9lula cont\u00e9m um erro ou n\u00e3o. O que precisamos fazer \u00e9 simplesmente inserir uma f\u00f3rmula na formata\u00e7\u00e3o condicional que possa verificar a condi\u00e7\u00e3o e retornar o resultado como VERDADEIRO ou FALSO. Voc\u00ea pode at\u00e9 verificar se h\u00e1 n\u00fameros, texto ou alguns valores espec\u00edficos nas c\u00e9lulas. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-en-evidence-les-erreurs-des-cellules-a-laide-de-la-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"destacar erros de c\u00e9lulas usando formata\u00e7\u00e3o condicional\"><\/figure><\/div><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> 6. Crie uma lista de verifica\u00e7\u00e3o com formata\u00e7\u00e3o condicional<\/h2><p> Agora vamos adicionar um pouco de criatividade \u00e0 intelig\u00eancia. Voc\u00ea j\u00e1 aprendeu como usar uma f\u00f3rmula baseada em outra c\u00e9lula. Aqui <a href=\"https:\/\/exceladvisor.org\/pt\/caixa-de-selecao\/\">vinculamos uma caixa de sele\u00e7\u00e3o<\/a> \u00e0 c\u00e9lula B1 e vinculamos B1 \u00e0 f\u00f3rmula usada na formata\u00e7\u00e3o condicional da c\u00e9lula A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-de-controle-utilisant-la-mise-en-forme-conditionnelle-et-la-case-a-cocher-1.png\" sizes=\"\" srcset=\"\" alt=\"lista de verifica\u00e7\u00e3o usando formata\u00e7\u00e3o condicional e caixa de sele\u00e7\u00e3o\"><\/figure><\/div><p> Agora, se voc\u00ea marcar a <a href=\"https:\/\/exceladvisor.org\/pt\/caixa-de-selecao\/\">caixa<\/a> , o valor da c\u00e9lula B1 se tornar\u00e1 TRUE e a c\u00e9lula A1 receber\u00e1 sua formata\u00e7\u00e3o condicional [ <a href=\"https:\/\/exceladvisor.org\/pt\/haste\/\">strichado<\/a> ]. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-liste-de-controle-dynamique-utilisant-des-formules-en-format-conditionnel-1.gif\" sizes=\"\" srcset=\"\" alt=\"uma lista de verifica\u00e7\u00e3o din\u00e2mica usando f\u00f3rmulas em formato condicional\"><\/figure><\/div><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> Aprendizado<\/h2><ol><li> Sua f\u00f3rmula deve ser l\u00f3gica, o que leva a um resultado VERDADEIRO ou FALSO.<\/li><li> Tente n\u00e3o sobrecarregar seus dados com formata\u00e7\u00e3o condicional.<\/li><li> Sempre use <a href=\"https:\/\/www.deskbright.com\/excel\/absolute-and-relative-cell-references\/\" target=\"_blank\" rel=\"noreferrer noopener\">refer\u00eancias relativas e absolutas<\/a> no sentido literal.<\/li><\/ol><h2 id=\"tab-con-10\" class=\"wp-block-heading\"> Arquivo de exemplo<\/h2><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formules-dans-la-mise-en-forme-conditionnelle-2.xlsx\" rel=\"nofollow\">Baixe este arquivo de amostra aqui<\/a> para saber mais.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/excel-avancado\/\">Tutoriais avan\u00e7ados de Excel<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/\">Op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/destacar-linhas-alternadas\/\">Destaque linhas alternativas no Excel com amostra de cores<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/jogos-de-icones\/\" data-wpil=\"url\">Use conjuntos de \u00edcones no Excel (formata\u00e7\u00e3o condicional)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-315","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)<\/title>\n<meta name=\"description\" content=\"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/formulas-1\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)\" \/>\n<meta property=\"og:description\" content=\"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/formulas-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:33:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/\",\"name\":\"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\",\"datePublished\":\"2023-11-04T19:19:59+00:00\",\"dateModified\":\"2023-12-06T11:33:33+00:00\",\"description\":\"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/formulas-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formulas-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)","description":"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em","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:\/\/exceladvisor.org\/pt\/formulas-1\/","og_locale":"pt_PT","og_type":"article","og_title":"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)","og_description":"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em","og_url":"https:\/\/exceladvisor.org\/pt\/formulas-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:33:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/","url":"https:\/\/exceladvisor.org\/pt\/formulas-1\/","name":"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no Excel (2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","datePublished":"2023-11-04T19:19:59+00:00","dateModified":"2023-12-06T11:33:33+00:00","description":"Regra n\u00ba 1: Na formata\u00e7\u00e3o condicional, sua f\u00f3rmula deve ser uma f\u00f3rmula l\u00f3gica e o resultado deve ser VERDADEIRO ou FALSO. Em","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/formulas-1\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-des-formules-dans-la-mise-en-forme-conditionnelle-pour-verifier-si-la-valeur-est-superieure-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/formulas-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"7 f\u00f3rmulas de formata\u00e7\u00e3o condicional no excel"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=315"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/315\/revisions"}],"predecessor-version":[{"id":752,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/315\/revisions\/752"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}