Microsoft Excel Conditional Formatting Essentials

Learn to apply conditional formatting in Excel to highlight cells by criteria, such as cells containing the word produce in yellow and sales under 1000 in red bold white text.

Master dynamic conditional formatting in Excel by using a formula to determine which cells to format, adjusting for relative and absolute references so formatting updates with changing criteria.

Apply conditional formatting to highlight the top 10 sales values, bottom 25% of attendance, and products sold above average using rank-based rules.

Apply conditional formatting to highlight the top two grades with bold green text and a prefix 'excellent!' before the score, updating dynamically as values change.

Learn to format duplicate values with Excel conditional formatting by creating a new rule to highlight duplicates in orange fill and bold black text in a customer database.

Apply icon sets in conditional formatting to format cells as a status KPI and trend arrows, using thresholds of 65 and 45 million to show up, straight, or down indicators.

Learn to apply icon sets in Excel to format cell values into five-state visual scores, using conditional formatting and the average function for an overall score.

Apply three-arrow icon sets to show trends, using green up arrows for positive values and red down arrows, with corresponding green and red font coloring via three conditional formatting rules.

Learn to apply conditional formatting with icon sets to mark values below 500 with a green icon, then suppress other icons by a second rule and stop if true.

Format cells with data bars using conditional formatting to visualize values through gradient and solid bars, including value-based and percentile 10–90 rules, in green, blue, yellow, and orange.

Format cells with color scales in conditional formatting to visualize ranks from low to high using two-color and three-color scales, red to blue, with a green midpoint.

Apply conditional formatting to highlight every other row using a formula based on the row and mod functions, using mod(row(),2)=1 to color alternating rows.

Apply conditional formatting to compare quarterly city sales to the annual total, highlighting >30% with blue bold double underline and 20% or less with red bold brackets using a formula.

Format an entire row based on set criteria with conditional formatting and the end function, using absolute references and range-wide formulas that yield true results.

Learn to format an entire row in Excel using a formula to identify unique values with countifs, then apply conditional formatting to highlight rows where the value appears only once.