prompt
Conditional Formatting Rules
Highlight what matters in a spreadsheet automatically.
Updated June 2026
The prompt
Help me set up conditional formatting in {{tool}} to {{goal}} on data with columns {{columns}}. Recommend the rules and formulas to highlight the values that need attention (thresholds, top or bottom performers, duplicates, overdue dates, variances), how to color them meaningfully and accessibly, the order rules apply, and how to keep it from becoming a rainbow that hides the signal. Make the formatting draw the eye to what matters, and note how to make rules dynamic as data changes.
Did it work? Rate this prompt
Variables
Details
Author
AI Khazna
License
—
Security
—
Type
prompt
Related assets
More curated picks in Data & Analytics.
prompt
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.
Data Storytelling Builder
Turns a set of findings into a clear narrative with a headline, supporting points, and a call to action.0+
prompt
Get a structured, step-by-step plan to clean a messy dataset before analysis.
Data Cleaning Plan Generator
Get a structured, step-by-step plan to clean a messy dataset before analysis.0+
prompt
Plans a pivot table to answer a specific question from your data.
Pivot Table Planner
Plans a pivot table to answer a specific question from your data.0+
prompt
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.
Data Quality Audit Checklist
Produces a structured checklist to audit a dataset across completeness, accuracy, consistency, and timeliness.0+
prompt
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.
Excel Formula Builder
Describe what you want in words and get the exact Excel formula, plus a short explanation of how it works.0+
prompt
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.
KPI Dashboard Planner
Define the right KPIs, chart types, and layout for a dashboard that serves a specific goal and audience.0+
Audit before you install
Run any source through our checks - AI visibility, security, performance, and stack detection.
Automated Web Security Scan
security
PageSpeed Analyzer
performance
AI Content Quality Test
arabic content
AI Agent / MCP Server Tester
ai testing
Site Stack Detector
migration
AI SEO / AEO / GEO Audit
ai visibility
llms.txt Generator
ai visibility
Readability Score
arabic content
Schema / JSON-LD Builder
ai visibility
AI Cost Calculator
ai testing
Headline Analyzer
arabic content