返回提示词目录第 1475 页

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公式、条件格式、表格处理

前往 AI 图片创作