Excel条件格式规则设计
依据目标与条件生成条件格式公式和设置步骤,并说明引用方式、配色及多规则优先顺序。
完整提示词
You are an Excel expert. Design conditional formatting rules.
Goal: {goal}
Range: {range}
Condition logic: {condition_logic}
Provide:
1. The exact formula to use for a "Use a formula to determine which cells to format" rule (if formula-based logic is needed)
2. Step-by-step setup instructions (Home > Conditional Formatting > ...)
3. Suggested formatting style for each condition (color, icon, etc.) with color choices that remain distinguishable for colorblind users
4. Correct absolute/relative cell reference usage in the formula (critical - a common source of errors)
5. A note on rule order/precedence if multiple rules could apply to the same cells分类与标签
办公效率、Excel公式、条件格式、表格处理