When using Conditional Formatting, users often ask about 3 areas: missing display results, rule priority, and visibility in collaboration; this section answers 3 common questions.
FAQ
Why is the color not showing after I set Conditional Formatting?
- Check whether the apply range covers the target cells.
- Check whether the condition value matches the actual data, such as whether the threshold is set too high.
- Open Manage Rules and confirm that the rule still exists and is in a suitable order.
Which format is shown when multiple rules are true at the same time?
- Open Manage Rules from Conditional Formatting.
- Review the order of the rules in the list.
- Adjust the priority and check the result again.
Can other collaborators see Conditional Formatting set in a shared file?
- Save the current document after setting the rules.
- Ask collaborators to reopen or sync the current file.
- Confirm that the same range shows the same conditional-formatting result.
Glossary
| Term | Definition |
|---|---|
| Conditional Formatting | A feature that changes the display style of cells automatically based on preset conditions. |
| Data Bars | A conditional-formatting style that uses bar length to show relative value size. |
| Color Scale | A conditional-formatting style that uses color depth or gradients to show data distribution. |
| Icon Set | A style that uses icons such as arrows or traffic lights to show levels or trends. |
| Rule Priority | A setting that determines the execution order when multiple conditional-formatting rules exist. |