Use Conditional Formatting with 5 how-to topics, all available without membership; choose a topic from the How-to Index and follow the menu path and steps to complete the task.

How-to Index

No.	Topic	Membership Requirement
1	1. View the feature entry and preset categories	Free
2	2. Create a new conditional formatting rule	Free
3	3. Create a preset rule quickly	Free
4	4. Manage existing rules	Free
5	5. Clear conditional formatting rules	Free

How-to Guide

1. View the feature entry and preset categories

Feature path: Data → Conditional Formatting

Select the cell range where you want to apply conditional formatting.
Click the Data tab at the top and select Conditional Formatting.
Review the preset categories in the drop-down menu.
Confirm that the available categories include Highlight Cells Rules, Top/Bottom/Average, Data Bars, Color Scales, Icon Sets, New Rule, Manage Rules, and Clear Rules.

Success Criteria

Interface result: The Conditional Formatting menu opens and the rule categories are visible.
Next action available: You can continue with preset rules, new rules, rule management, or clearing rules.

Tips While Using

Common mistake: If you do not select the target range first, the rule may be applied to an unexpected area.

2. Create a new conditional formatting rule

Feature path: Data → Conditional Formatting → New Rule

Select the cell range where you want to apply conditional formatting.
Click Conditional Formatting and choose New Rule.
In the New Conditional Formatting panel on the right, confirm or change the apply range.
Choose a rule type such as Highlight Cells Rules, Top/Bottom/Average, Data Bars, Color Scales, or Icon Sets.
Set the condition field, comparison operator, and the value or formula.
In the display area, choose a preset style or customize the font, border, and fill color.
Click Create Rule to apply the rule.

Success Criteria

Interface result: The target range displays the format that matches the rule.
Next action available: You can return to the panel to edit the rule or add more rules.

Tips While Using

Common mistake: If the condition value or formula is inaccurate, no cells may be highlighted.
Environment note: When you use a formula rule, make sure the references match the target range.

3. Create a preset rule quickly

Feature path: Data → Conditional Formatting → preset category submenu

Select the cell range where you want to apply the rule.
Click Conditional Formatting and choose a preset category such as Highlight Cells Rules.
In the submenu, choose a specific rule such as Greater Than, Less Than, Equal To, or Text Contains.
Enter the condition value in the pop-up input box.
Choose the display format and confirm.

Success Criteria

Interface result: Cells that meet the condition immediately display the selected style.
Next action available: You can add more rules or open the rule management view.

Tips While Using

Common mistake: If the input value type does not match the cell content type, the result may not match your expectation.

4. Manage existing rules

Feature path: Data → Conditional Formatting → Manage Rules

Click Conditional Formatting and choose Manage Rules, or open rule management from the bottom of the new rule panel.
In the rule management view, review the rule list for the current worksheet or selected range.
Select the rule you want to adjust and edit the condition or display format.
Use move-up or move-down controls to adjust rule priority.
If needed, create more rules and save the updated result.

Success Criteria

Interface result: The rule list is updated, and changes to priority or conditions are reflected in the worksheet.
Next action available: You can continue editing, adding, or deleting other rules.

Tips While Using

Common mistake: When multiple rules match at the same time, ignoring priority can affect the final display result.

5. Clear conditional formatting rules

Feature path: Data → Conditional Formatting → Clear Rules

Select the cell range where you want to remove conditional formatting.
Click Conditional Formatting and choose Clear Rules.
Choose either Clear Rules from Selected Cells or Clear Rules from Entire Worksheet, depending on your need.
Run the clear action and return to the worksheet to review the result.

Success Criteria

Interface result: Conditional formatting is removed from the selected range or the entire worksheet.
Next action available: You can create new conditional formatting rules again.

Tips While Using

Common mistake: If you clear rules for the entire worksheet, all conditional formatting in the current worksheet will be removed.