
Welcome to the course
Explore conditional formatting basics in Excel, from built-in shortcuts to custom rules, and learn to highlight values, above/below average, unique or duplicate values, and formula-based formats for clearer data.
Apply conditional formatting in Excel to highlight sales values above or below 5000, using range selection and rules, with green for high values and red or orange for low values.
Learn how to apply Excel conditional formatting to highlight values between five thousand and seven and a half, include boundaries, and manage rules for practice.
Apply conditional formatting to highlight cells based on text contains, using specific text and equal to rules, with practical examples for John, France, and Brazil.
Clarify how conditional formatting rules work: current selection vs worksheet scope, rule order effects, duplicates, and stop if true, with examples using age and red/blue formats.
Learn data bars in Excel conditional formatting to visualize cell values, adjusting minimum and maximum, percentile options like 10 and 90, and bar styles such as gradient or solid fills.
Apply a three-color scale to the age column to improve readability, using green-yellow-red colors and the built-in percentile 50 rule, while noting min-zero caveats.
Explore icon sets in conditional formatting to improve data readability, adjust thresholds, and mix with data bars for flexible, visualized sales data.
Clarifies how percentage versus percentile affects color thresholds in Excel icon sets and demonstrates top third ranking.
Apply excel conditional formatting to highlight top and bottom values in mathematics, physics, and English. Use top 10 and bottom 10 rules per column to avoid mixing data.
Apply top and bottom percent rules in Excel conditional formatting to highlight the top and bottom percent students, using blue and red fills in a 40-student example.
Apply conditional formatting in Excel to highlight above average values in green and below average values in red using top-to-bottom rules and the new rule option.
Learn how to highlight unique and duplicate values in Excel using conditional formatting. Apply formats such as green for uniques and light red for duplicates for quick visual insights.
Apply formula-based conditional formatting to a selected range to color rows by gender. Learn to use formulas to determine which cells to format and how the formatting adjusts across rows.
Apply conditional formatting with formulas to highlight cells based on age and year, practicing highlighting the first three columns when age exceeds 50 and years between 2000 and 2010.
Apply sum, sumif, and if to evaluate sales against goals using conditional formatting that flags overall and per-country success in green or red.
Combine excel functions and conditional formatting to analyze sales data, using max, vlookup, match, and countif to compare correct and incorrect records and daily sales for beginners and intermediate users.
Identify top performers by highlighting annual sales above average, compare monthly sales to goals with a formula using locks on rows and columns, and visualize monthly analysis with conditional formatting.
learn to apply excel conditional formatting from basics to formulas, using icon sets, percentile adjustments, top/bottom rules, max, vlookup, and match to identify monthly top salesmen.
Apply excel conditional formatting from the final series exercises 7–10, using countif to spot mistakes, highlight fake employees, and flag last week and October sales over 10.
Highlight Roland Garros champions who won more than three times with conditional formatting formulas; flag five-set finals using len and substitute to count commas.
This course is about automatically formatting your Data with Colors, Icons, Bars (and more) using the Conditional Formatting feature of Excel.
The student will learn Conditional Formatting from the very basics to formula use within the tool. Most of the topics on conditional formatting are covered: basic formatting (Equal, Greater than, Smaller than etc.), formatting with text, etc. We also cover Data Bars, Icon Sets and Color Scales. Finally a good portion of the course is dedicated to formula use within the conditional formatting.