[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel represents the go-to solution for data storage and representation for most business teams. Whether you work in finance, human resources, or marketing, the amount of data is definitely going to determine your analysis and visualization tasks. Thankfully, Excel offers a feature known as conditional formatting, which helps users organize and manage their whole data set in a few clicks. To make the most out of this rule-based feature, you must become familiar with how to use it correctly.<\/p>\n
In this complete guide, you\u2019ll learn what conditional formatting is and the many uses it offers in Excel. You\u2019ll learn the basics of conditional formatting in Excel and also learn its more advanced uses when combined with IF or AND formulas. What is great about this feature in Excel is that it can be as basic or as complex as you need, depending on the level of customization your data requires. From setting multiple conditions to formatting rules to selecting which spreadsheet data it should apply to, conditional formatting is one of the most valuable features in Excel to boost productivity at all company levels.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”what-is-conditional-formatting-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Conditional formatting is a spreadsheet application feature that allows users to format data following a set of built-in or customized conditions. The most common use is to highlight key information through color-coding or remove duplicate content in one click.<\/p>\n
The conditions or rules you set will apply to a cell or cell range, which can include columns; this means that the data in the cell will automatically change to the value specified in the rule. For example, you can ask Excel to highlight (for example, in the color green) all cells that contain a numeric value \u201cgreater than\u201d the amount specified. This type of condition will change the color format, but you can add other formatting aspects, such as the font size or style.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-does-conditional-formatting-work-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Conditional formatting changes the formatting of your data with conditions that act as \u201cIf\/Then\u201d statements. You set the condition of the rule to a specified cell range, and then determine the formatting style which will be applied to the cells that fulfill this rule. In other words, \u201cIf (data range) is (condition of rule), then (formatting style)” is applied.<\/p>\n
Depending on the complexity of the rule you would like to apply, from basic to more advanced, you can create the following types of conditions in Excel:<\/p>\n
[\/et_pb_text][et_pb_text module_id=”basic-types-of-conditional-formatting-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
We\u2019ll start by showing the most popular conditional formatting types in Excel based on their ease of use and applicability. Note that the examples shown are based on the Excel desktop app for Mac. Excel for the web also lets you create and edit conditional formatting rules, but its menus look a little different.<\/p>\n
This type of conditional formatting is one of the most commonly used in Excel since it helps to highlight key information and to structure your data visually so that it becomes more digestible, especially when dealing with large datasets.<\/p>\n
For example, let\u2019s say I work in the sales department of an international car dealership, and I need to report which car models have yielded above the expected profit margin. This is how to apply conditional formatting to change the cell color based on the cell value:<\/p>\n
1.<\/strong> Select the cell range you would like to apply the rule to. Here, we will select a cell range within the \u2018Profit 5%\u2019 column. Head to Conditional Formatting > Highlight Cells Rules > Greater Than.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-greater-than-menu.webp” alt=”Excel conditional formatting \u2014 Highlight Cells Rules menu open with Greater Than selected over the Profit 5% column” title_text=”Highlight Cells Rules menu open with Greater Than selected over the Profit 5% column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Highlight Cells Rules<\/p>\n 2.<\/strong> Before setting the color, enter the condition that the data should meet. In this case, the cell value should be greater than 1,000. Now, add the formatting style. Here, let\u2019s format all cells that meet the condition with the pre-set formatting \u201cGreen Fill with Dark Green Text\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-greater-than-rule.webp” alt=”Excel conditional formatting \u2014 New Formatting Rule dialog with Cell Value greater than 1,000 and Green Fill with Dark Green Text” title_text=”New Formatting Rule dialog with Cell Value greater than 1,000 and Green Fill with Dark Green Text” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Highlight Cells Rules Format<\/p>\n 3.<\/strong> Click \u201cOK\u201d. All cells above the specified value will be color-formatted as specified.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-cells-highlighted-green.webp” alt=”Excel conditional formatting \u2014 Profit 5% values above 1,000 highlighted in green” title_text=”Profit 5% values above 1,000 highlighted in green” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Cells highlighted in green<\/p>\n As you will be able to see, Excel provides a full range of color formatting rules that can be applied to any data type, not only numbers. Moreover, the last highlighting rule applies to duplicate values, which is useful for later removal or simply as a way of quickly visualizing repeat information. You will find our article on how to find and remove duplicates in Excel<\/a> very useful.<\/p>\n In the same way that applying a conditional formatting rule to a cell or cell range, you can also apply it to a column – simply highlight the entire column before using the feature. Here\u2019s how to conditionally format a column in Excel using the \u201cTop\/Bottom Rules\u201d.<\/p>\n 1.<\/strong> Highlight the column you would like to conditional format. Go to Conditional Formatting > Top\/Bottom Rules > Below Average. In this case, I want to highlight the profit value that is below the average, based on the values provided in the column.<\/p>\n Conditional Formatting in Excel – Top\/Bottom Rules Below Average<\/p>\n 2.<\/strong> In the dialog box, simply change the highlighting format according to your preference. Since I\u2019m going for a negative value, I will use \u201cLight Red Fill with Dark Red\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-below-average-rule.webp” alt=”Excel conditional formatting \u2014 New Formatting Rule dialog set to below the average with Light Red Fill with Dark Red Text” title_text=”New Formatting Rule dialog set to below the average with Light Red Fill with Dark Red Text” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Conditional format a column<\/p>\n 3.<\/strong> Excel will automatically highlight in red the profit values that are below the average.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-below-average-red.webp” alt=”Excel conditional formatting \u2014 below-average Profit 5% values highlighted in light red” title_text=”Below-average Profit 5% values highlighted in light red” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Below average in light red<\/p>\n [\/et_pb_text][et_pb_text module_id=”advanced-types-of-conditional-formatting” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that we have seen the basic uses of conditional formatting in Excel, let\u2019s explore more advanced options that will let you customize the rules according to your specific needs.<\/p>\n So far, we have seen examples of using conditional formatting in Excel with built-in rules, such as \u201cHighlight Cells Rules\u201d or \u201cTop\/Bottom Rules\u201d. But what if you want to apply more than one rule at the same time? Luckily, you are already using Excel and this means that you have a range of formulae to apply. Let’s see how the COUNTIF formula can be used with conditional formatting.<\/p>\n If you would like to conditionally format cells that contain duplicate values, you can use the built-in rule in Conditional formatting > Highlight Cells Rules > Duplicate Values\u2026<\/p>\n Conditional Formatting in Excel – Highlight duplicate values<\/p>\n However, you may also want to conditionally format the other columns or rows containing those duplicate values. The =COUNTIF formula in Excel<\/a> is used to count the number of cells within a selected range that meet a specified criterion.<\/p>\n Let\u2019s see how the =COUNTIF formula works by explaining its parameters:<\/p>\n This is how you can highlight duplicate values using the =COUNTIF formula in Excel:<\/p>\n 1.<\/strong> Select your cell range and go to Conditional Formatting > New Rule.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-formula-new-rule.webp” alt=”Excel conditional formatting formula \u2014 Conditional Formatting menu with New Rule and the YEAR column selected” title_text=”Conditional Formatting menu with New Rule and the YEAR column selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Create New Rule<\/p>\n 2.<\/strong> A dialog box will pop up. Select \u201cClassic\u201d in the \u201cStyle\u201d field, and \u201cUse a formula\u2026\u201d from the drop-down menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-formula-rule-type.webp” alt=”Excel conditional formatting formula \u2014 New Formatting Rule dialog with Use a formula to determine which cells to format” title_text=”New Formatting Rule dialog with Use a formula to determine which cells to format” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – New formatting rule options<\/p>\n 3.<\/strong> Below, in the formula field, enter your formula. In this example, I\u2019ll enter =COUNTIF(C1, "2006"), where the range is C1, corresponding to the \u2018YEAR\u2019 column, and \u201c2006\u201d the value I would like to find the duplicates of.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/countif-conditional-formatting-formula.webp” alt=”COUNTIF conditional formatting \u2014 COUNTIF formula on cell C1 for the year 2006 in the formula field” title_text=”COUNTIF formula on cell C1 for the year 2006 in the formula field” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – COUNTIF Formula<\/p>\n 4.<\/strong> Set the format to the color of your preference. Here I have set it to yellow.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/countif-conditional-formatting-yellow-fill.webp” alt=”COUNTIF conditional formatting \u2014 COUNTIF rule set to Yellow Fill with Dark Yellow Text” title_text=”COUNTIF rule set to Yellow Fill with Dark Yellow Text” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Format COUNTIF Formula to yellow<\/p>\n Once you click \u201cOK\u201d, you should be able to see all 2006 duplicates in yellow.<\/p>\n We have now used an Excel formula, =COUNTIF, with the \u201cDuplicate Cells\u201d conditional formatting rule. Let\u2019s now illustrate how multiple conditions can be applied based on the type of data and the type of formatting we would like to apply.<\/p>\n The AND formula is also a logical function that tests the conditions to return one of the true\/false values, depending on whether they are met or not.<\/p>\n To combine AND with IF inside a cell, see how to use the IF AND function combination in Excel<\/a>.<\/p>\n Following the use case, let\u2019s say that I want to conditionally format the VIN (Vehicle Identification Number) values or registered cars from 2006 onwards and that have yielded a profit value above the minimum, $1,153.00.<\/p>\n 1.<\/strong> Follow steps 1 & 2 shown in the previous section to create a new rule. Don\u2019t forget to select the cell range you wish to apply the multiple conditions to.<\/p>\n 2.<\/strong> Include the AND formula in the corresponding box. In this example, I’ll input the formula =AND(C1>=2006, F1>=1153). Type 1153 without the thousands separator, because Excel reads a comma inside a formula as the start of a new argument.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-formula-and-rule.webp” alt=”Excel conditional formatting formula \u2014 AND formula on the YEAR and Profit 5% columns in the New Formatting Rule dialog” title_text=”AND formula on the YEAR and Profit 5% columns in the New Formatting Rule dialog” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Format using AND Formula<\/p>\n 3.<\/strong> Change the formatting style to your preference. Here, I have chosen the \u201cGreen Fill with Dark Green Text\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-formula-and-green-fill.webp” alt=”Excel conditional formatting formula \u2014 AND formula rule set to Green Fill with Dark Green Text” title_text=”AND formula rule set to Green Fill with Dark Green Text” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Format AND Formula to green<\/p>\n 4.<\/strong> Press \u201cOK\u201d to apply your conditions. As shown below, Excel highlights in green only the cell values that meet the multiple conditions set in the AND formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-formula-and-result.webp” alt=”Excel conditional formatting formula \u2014 VIN cells that meet both AND conditions highlighted in green” title_text=”VIN cells that meet both AND conditions highlighted in green” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – AND Formula applied<\/p>\n What if, instead of applying a rule to a given value, you want to base it on the value of another cell in the spreadsheet? This cell value will act as the fixed value when applying the highlighting rule. If we continue with the car profit margin example, the highlight was included in the formatting when a numeric value exceeded the expected profit value. However, since the profit margin value might change over time, we might prefer to create a rule that strictly depends on a controlled value. This is how you can conditionally format an Excel cell based on another cell.<\/p>\n 1.<\/strong> In the same worksheet, add your controlled value to a cell. Here, I will add my controlled value (\u2018Min profit\u2019) of $1,153.00 (Column H) to the right of my current table.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-another-cell-min-profit.webp” alt=”Excel conditional formatting based on another cell \u2014 Min Profit of 1,153.00 US$ added in cell H2″ title_text=”Min Profit of 1,153.00 US$ added in cell H2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Based on another cell<\/p>\n 2.<\/strong> Go to Conditional Formatting > New Rule.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-another-cell-new-rule.webp” alt=”Excel conditional formatting based on another cell \u2014 Conditional Formatting menu with New Rule selected” title_text=”Conditional Formatting menu with New Rule selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Create New Rule<\/p>\n 3.<\/strong> A dialog box will pop up, select \u201cClassic\u201d in the \u201cStyle\u201d field, and \u201cUse a formula to determine which cells to format\u201d from the drop-down menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-another-cell-use-formula.webp” alt=”Excel conditional formatting based on another cell \u2014 rule type list with Use a formula to determine which cells to format” title_text=”Rule type list with Use a formula to determine which cells to format” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – Use formula to format<\/p>\n 4.<\/strong> Below, in the formula field, select the cell containing your controlled value, here shown as “$H$2”. To highlight only the profits above that minimum, select the Profit 5% values starting at F2 and enter the comparison as the rule, for example =F2>$H$2.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-conditional-formatting-another-cell-h2-rule.webp” alt=”Excel conditional formatting based on another cell \u2014 =$H$2 entered in the formula field next to the Min Profit cell” title_text=”=$H$2 entered in the formula field next to the Min Profit cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional Formatting in Excel – New rule with controlled value<\/p>\n Any value above the one specified will now be highlighted according to this conditional formatting rule. Now you know how to create a dynamic rule, as the minimum profit changes, the rule will adjust to the fixed value.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Conditional formatting in Excel has proven to be a versatile tool. As this guide has shown, the built-in rules already save you time on repetitive daily tasks by performing editing actions in bulk, such as color-coding or removing duplicate cells. If you would like Excel to perform more advanced actions, where multiple conditions or more sophisticated criteria need to be applied, it will also allow you to combine these with formulae.<\/p>\n You can now save time in cleaning and organizing large or smaller datasets. Hopefully, this guide has shown that an Excel spreadsheet goes beyond a data storage system and represents an all-around reference for business tasks related to planning, organizing, and decision-making.<\/p>\n If you would like to try conditional formatting functionality in Google Sheets, read our article on how to use conditional formatting in Google Sheets<\/a>. To flag repeated entries there, see how to highlight duplicates in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a usar a formata\u00e7\u00e3o condicional no Excel, das regras integradas para real\u00e7ar c\u00e9lulas at\u00e9 escrever uma f\u00f3rmula de formata\u00e7\u00e3o condicional com COUNTIF, AND ou outra c\u00e9lula.<\/p>","protected":false},"author":2,"featured_media":264670,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-264653","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=264653"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/264653\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/264670"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=264653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=264653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=264653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How do I conditionally format a column in Excel?<\/h3>\n
Advanced types of conditional formatting in Excel<\/h2>\n
Can I use Excel conditional formatting with a formula?<\/h3>\n
=COUNTIF formula to highlight duplicates<\/h4>\n
=COUNTIF formula syntax<\/h4>\n
\n
Conditional formatting using COUNTIF: How to remove duplicates<\/h4>\n
How to use Excel conditional formatting when applying multiple conditions?<\/h3>\n
AND formula to apply multiple conditions<\/h4>\n
How do I conditionally format a cell based on another cell in Excel?<\/h3>\n
Conclusion<\/h2>\n