Guide to Using Conditional Formatting Feature in AirSheet

Feature Summary

The conditional formatting feature allows users to automatically change the display style of cells based on set rules. When cell content meets the conditions, the specified format is automatically applied, suitable for scenarios such as data highlighting and anomaly identification.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction

Operation Steps

Feature Entry and Preset Categories

Feature Entry
「Data」 tab → 「Conditional Formatting」 button

1. Select the cell range where you want to set conditional formatting
2. Click the 「Conditional Formatting」 button in the Data tab
3. A dropdown menu will appear, containing the following preset categories:

• Highlight Cells: Greater Than, Less Than, Between, Equal To, Text Contains, Date Occurring, Duplicate Values, More Rules
• Top/Bottom/Average: Top 10, Bottom 10%, Above Average, Below Average, etc.
• Data Bars: Visually display value magnitude with colored bars
• Color Scales: Show data distribution with color gradients
• Icon Sets: Mark data levels with icons such as arrows and traffic lights
• New Rule: Custom conditional formatting rules
• Manage Rules: View and edit existing rules
• Clear Rules: Delete set conditional formatting

New Rule

Feature Entry
「Data」 tab → 「Conditional Formatting」 → 「New Rule」

1. Select the cell range where you want to set conditional formatting
2. Click 「Conditional Formatting」 → 「New Rule」 in the Data tab
3. The 「New Conditional Formatting」 panel will pop up on the right. Configure it with the following steps:

• Applies to: Confirm or modify the cell range to apply
• When rules are met: Select the rule type (Highlight Cells / Top/Bottom/Average / Data Bars / Color Scales / Icon Sets, etc.)
• Condition Settings: Select the judgment field (e.g., 「Cell Value」) and comparison operator (e.g., 「Greater Than」, 「Equal To」, 「Text Contains」, etc.)
• Value or Formula: Enter the specific condition value, supporting direct input of values or formulas
• Display as: Select a preset style (e.g., 「Light Red Background + Red Text」), or customize via the format buttons below:
• B Bold / I Italic / U Underline
• Font Color / Border / Fill Color

4.After setting, click the 「Create Rule」 button to apply

5.If you need to reset, click 「Reset」 to clear the current configuration

Quick Create Preset Rules

Feature Entry
「Data」 tab → 「Conditional Formatting」 → Submenu of preset categories

1. Select the cell range where you want to set conditional formatting
2. Click 「Conditional Formatting」 in the Data tab, select a preset category, such as 「Highlight Cells」 → 「Greater Than」
3. Enter the condition value in the pop-up input box (e.g., 100)
4. Select or customize the display format
5. Click OK, and cells that meet the condition will automatically apply the corresponding format

Manage Rules

Feature Entry
「Data」 tab → 「Conditional Formatting」 → 「Manage Rules」 / Bottom of the right panel → 「Manage Conditional Formatting」 link

1. Select the cell range where you want to manage rules
2. Click 「Conditional Formatting」 → 「Manage Rules」 in the Data tab, or click the 「Manage Conditional Formatting」 link at the bottom of the new rule panel
3. The rule management interface will pop up, where you can perform the following operations:

• View Rule List: Display all conditional formatting rules for the current sheet or current selection
• Modify Rules: Double-click a rule to edit its condition judgment and display format
• Adjust Priority: Select a rule and click the Move Up/Move Down buttons to adjust the execution order of rules (higher priority for those at the top)
• New Rule: Click 「New Rule」 to add a new rule in the management interface

Clear Rules

Feature Entry
「Data」 tab → 「Conditional Formatting」 → 「Clear Rules」 submenu

1. Select the cell range where you want to clear conditional formatting
2. Click 「Conditional Formatting」 → 「Clear Rules」 in the Data tab
3. Select the clearing scope in the submenu:

• Clear Rules from Selected Cells: Only clear conditional formatting from the currently selected area
• Clear Rules from Entire Sheet: Clear all conditional formatting in the current sheet

4.After clicking, the conditional formatting in the corresponding area will be immediately removed

FAQ

Q1: Why doesn't the color display after setting conditional formatting?

• Solution: Check if the applied range correctly covers the target area; confirm if the condition value is reasonable (e.g., if 「Greater Than 1000」 is set to 「Greater Than 10000」, there will be no match).

Q2: When multiple rule conditions are met, which format is displayed?

• Solution: Conditional formatting is executed in order of priority from top to bottom, with rules at the top having higher priority. You can adjust the order by moving rules up or down in 「Manage Rules」 to change the display effect.

Question 3: Do conditional formatting rules still apply when switching devices?

• Solution: Yes, conditional formatting rules are saved in the document, so they still apply when the Sheets is opened by another account or on another device.

Notes

• Conditional formatting rules are saved with the document, and all collaborators will see the same effects.
• Clearing rules cannot be undone. It is recommended to confirm that you no longer need them before proceeding.
• In custom formula conditional formatting, cell references must use absolute references (the $ symbol).