Feature Summary

The Conditional Formatting feature automatically applies formats (such as colors, icons, and so on) based on cell content, helping you quickly identify patterns, outliers, and trends in your data.

Feature Description

Feature Dimension Description
Membership Restrictions No membership restrictions
Version Restrictions No version restrictions

Operation Steps

Highlight Cells Rules

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Highlight Cells Rules" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Highlight Cells Rules" ** option in the Conditional Formatting dropdown menu
  4. Automatically highlight cells that meet specific conditions based on value, text, date, etc., to quickly identify key data

image

Top/Bottom Rules

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Top/Bottom Rules" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Top/Bottom Rules" ** option in the Conditional Formatting dropdown menu
  4. Quickly mark the top N items, bottom N items, or items above/below average in the data, making it easier to filter out standout data

image

Data Bars

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Data Bars" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Data Bars" ** option in the Conditional Formatting dropdown menu
  4. Display a horizontal bar chart within the cells, where the bar length corresponds to the value size, allowing for intuitive comparison of data differences

image

Color Scales

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Color Scales" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Color Scales" ** option in the Conditional Formatting dropdown menu
  4. Represent value levels through color gradients (e.g., Red-Yellow-Green) to visually display data distribution and trends

image

Icon Sets

Feature Entry "Home" tab → "Conditional Formatting" dropdown menu → "Icon Sets" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Icon Sets" ** option in the Conditional Formatting dropdown menu
  4. Classify data using icons such as arrows, flags, and traffic lights to intuitively distinguish data levels or change trends

image

New Rule

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "New Rule" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "New Rule" ** option in the Conditional Formatting dropdown menu
  4. Customize conditional formatting rules, supporting various condition types such as formulas, rankings, and duplicate values to meet complex needs

image

Clear Rules

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Clear Rules" option

  1. Select the cell range from which you want to clear conditional formatting
  2. Select the Home tab
  3. Click the ** "Clear Rules" ** option in the Conditional Formatting dropdown menu
  4. Delete conditional formatting rules from the selected cells or the entire worksheet, removing only the formatting without affecting the original data

image

Manage Conditional Formatting Rules

Feature Entry

"Home" tab → "Conditional Formatting" dropdown menu → "Manage Rules" option

  1. Select the cell range to which you want to apply conditional formatting
  2. Select the Home tab
  3. Click the ** "Manage Rules" ** option in the Conditional Formatting dropdown menu4. View, edit, and delete existing rules
  4. Adjust rule priority order

image

FAQ

Q1: Can I set multiple rules for conditional formatting?

  • Solution: You can set multiple conditional formatting rules for the same range, and they will be executed in priority order.

Q2: How do I clear conditional formatting?

  • Solution: Click "Conditional Formatting" → "Clear Rules" to clear rules from the selected cells or the entire worksheet.

Notes

  • Conditional formatting updates automatically as data changes
  • Rule priority affects the final display effect
  • Data bars, color scales, and icon sets are common visualization methods