Back to guide/General Productivity

Conditional Formatting Rules

Specifying rules in plain English with examples is faster than trying to figure out conditional formatting dialogs. Asking about rule conflicts prevents formatting that silently overrides itself.

chatgpt-prompts-for-excelrangewhat_the_data_representsrule_1
Edit View
Prompt
Set up conditional formatting rules for my Excel sheet:

**Range:** {{range}} (e.g., "A2:F500")
**Data description:** {{what_the_data_represents}}

I want to highlight:
1. {{rule_1}} (e.g., "cells in Column C > 1000 → green background")
2. {{rule_2}} (e.g., "cells in Column D with text 'Overdue' → red text, bold")
3. {{rule_3}} (e.g., "entire row where Column E is blank → yellow background")

For each rule, provide:
- The exact steps in Excel (Home > Conditional Formatting > ...)
- If a custom formula is needed, provide the formula
- The order the rules should be applied (priority matters)

Also flag if any rules might conflict with each other.

Variables to customize

{{range}}{{what_the_data_represents}}{{rule_1}}{{rule_2}}{{rule_3}}

Why this prompt works

Specifying rules in plain English with examples is faster than trying to figure out conditional formatting dialogs. Asking about rule conflicts prevents formatting that silently overrides itself.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.