Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Conditional Formatting | Advanced Formulas and Functions
Excel Essentials
course content

Зміст курсу

Excel Essentials

Excel Essentials

1. Introduction to Excel
IntroductionGetting Acquainted with ExcelExcel InterfaceEntering DataChallenge
2. Entering and Formatting Data
Formatting CellsFormatting TextFormatting NumbersChallenge
3. Basic Formulas and Functions
Introduction to Formulas and FunctionsUsing Cell ReferencesUnderstanding RangesCommon FunctionsApplication of INSERT FUNCTIONChallenge
4. Advanced Formulas and Functions
Displaying and Highlighting FormulasIF Logical Test and Relational OperatorsNested IF StatementsCompound Logical Tests with AND, ORUsing Auditing ToolsConditional FormattingChallenge
5. Data Management and Analysis
Sorting DataFiltering Data Using AutoFilterClearing and Reapplying FiltersRules and SearchCreating and Managing TablesTable Styles and Quick Formatting OptionsUsing Table ToolsChallenge
6. Visualizing Data with Charts and Graphs
Types of ChartsCreating a Basic ChartCustomizing Chart ElementsChanging Chart Styles and ColorsAdding and Removing Chart ElementsEditing Data in ChartsAdding Trendlines to ChartsChallenge
7. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesChallengeSummary

Conditional Formatting

Conditional formatting in Excel is like giving your data a visual makeover. It allows you to automatically apply specific formatting to cells that meet certain criteria.

This feature makes it easier to spot patterns, trends, and outliers in your data, turning a sea of numbers into insightful, color-coded information.

Key Points

  • Apply conditional formatting using the Highlight Cells Rules for specific criteria;
  • Use the Top/Bottom Rules to format cells with the highest or lowest values;
  • Add Data Bars to visually represent cell values;
  • Apply Color Scales to show value ranges with a gradient of colors;
  • Use Icon Sets to represent different values with icons;
  • Create custom conditional formatting rules using formulas.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Mark tasks as Completed

Все було зрозуміло?

Секція 4. Розділ 6

Choose your plan

Conditional Formatting

Conditional formatting in Excel is like giving your data a visual makeover. It allows you to automatically apply specific formatting to cells that meet certain criteria.

This feature makes it easier to spot patterns, trends, and outliers in your data, turning a sea of numbers into insightful, color-coded information.

Key Points

  • Apply conditional formatting using the Highlight Cells Rules for specific criteria;
  • Use the Top/Bottom Rules to format cells with the highest or lowest values;
  • Add Data Bars to visually represent cell values;
  • Apply Color Scales to show value ranges with a gradient of colors;
  • Use Icon Sets to represent different values with icons;
  • Create custom conditional formatting rules using formulas.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Mark tasks as Completed

Все було зрозуміло?

Секція 4. Розділ 6

Choose your plan

Conditional Formatting

Conditional formatting in Excel is like giving your data a visual makeover. It allows you to automatically apply specific formatting to cells that meet certain criteria.

This feature makes it easier to spot patterns, trends, and outliers in your data, turning a sea of numbers into insightful, color-coded information.

Key Points

  • Apply conditional formatting using the Highlight Cells Rules for specific criteria;
  • Use the Top/Bottom Rules to format cells with the highest or lowest values;
  • Add Data Bars to visually represent cell values;
  • Apply Color Scales to show value ranges with a gradient of colors;
  • Use Icon Sets to represent different values with icons;
  • Create custom conditional formatting rules using formulas.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Все було зрозуміло?

Conditional formatting in Excel is like giving your data a visual makeover. It allows you to automatically apply specific formatting to cells that meet certain criteria.

This feature makes it easier to spot patterns, trends, and outliers in your data, turning a sea of numbers into insightful, color-coded information.

Key Points

  • Apply conditional formatting using the Highlight Cells Rules for specific criteria;
  • Use the Top/Bottom Rules to format cells with the highest or lowest values;
  • Add Data Bars to visually represent cell values;
  • Apply Color Scales to show value ranges with a gradient of colors;
  • Use Icon Sets to represent different values with icons;
  • Create custom conditional formatting rules using formulas.

Завдання

  • Select cells D22 to G28. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background.
  • Select cells D22 to G28. Click Less Than. Type 70 and select a red background.
  • Select cells C8 to F14. Click Top/Bottom Rules > Bottom 10 Items. Select a red background.
  • Select cells G8 to G14. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color.
  • Select cells D22 to G28. Click Conditional Formatting > Color Scales. Choose one.
  • Select cells D22 to G28. Click Conditional Formatting > Icon Sets. Choose one of the sets.
  • Select cells B8 to H41. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type =ISFORMULA(B8). Click on Format, choose a color, and click OK.

Секція 4. Розділ 6
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
We're sorry to hear that something went wrong. What happened?
some-alt