What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Test your conditional formatting rules on a small data sample first to ensure they work correctly Use color combinations that are accessible - avoid red/green only combinations for colorblind users Start with the most important condition first, as later rules may override earlier ones Use absolute cell references ($) in formulas when you want to compare against fixed ranges Keep formatting subtle enough that the data remains readable - avoid overly bright colors

data beginner

Create Conditional Formatting Rules for Spreadsheets

Generate smart conditional formatting rules for Excel and Google Sheets. Highlight data patterns, track performance, and visualize trends automatically.

Works with: chatgptclaudegemini

Prompt Template

I need help creating conditional formatting rules for my spreadsheet data. Please provide detailed conditional formatting rules for the following scenario: Data type: [DATA_TYPE] Spreadsheet application: [SPREADSHEET_APP] Data range: [DATA_RANGE] Goal: [FORMATTING_GOAL] Specific conditions to highlight: [CONDITIONS] For each rule, please provide: 1. A clear description of what the rule does 2. The exact condition/formula to use 3. The recommended formatting (colors, fonts, etc.) 4. Step-by-step instructions for applying the rule in [SPREADSHEET_APP] 5. Any additional tips for optimization If there are multiple conditions, please prioritize them by importance and explain how they work together. Also suggest any complementary formatting rules that might enhance the visual analysis of this data. Make the rules beginner-friendly with clear explanations of why each formatting choice helps with data interpretation.

Variables to Customize

[DATA_TYPE]

Type of data you're working with

Example: Sales performance data with revenue, targets, and dates

[SPREADSHEET_APP]

Which spreadsheet application you're using

Example: Google Sheets

[DATA_RANGE]

The range of cells containing your data

Example: A1:D50 containing columns for Date, Salesperson, Revenue, and Target

[FORMATTING_GOAL]

What you want to achieve with the formatting

Example: Highlight top performers, identify underperformers, and track monthly trends

[CONDITIONS]

Specific conditions or thresholds you want to highlight

Example: Revenue above target (green), revenue below 80% of target (red), top 10% performers (bold)

Example Output

Here are conditional formatting rules for your sales performance data in Google Sheets: **Rule 1: Revenue vs Target Performance** - Description: Highlights cells where revenue exceeds target in green, and underperformers in red - Condition: Custom formula `=$C2>$D2` (for green), `=$C2<$D2*0.8` (for red) - Formatting: Green background (#00FF00) for overperformers, red background (#FF0000) for underperformers - Steps: Select range C2:C50 → Format → Conditional formatting → Custom formula is → Enter formula → Choose colors **Rule 2: Top 10% Performers** - Description: Makes top performers stand out with bold text and blue background - Condition: Custom formula `=PERCENTRANK($C$2:$C$50,C2)>=0.9` - Formatting: Bold text, blue background (#4285F4) - Steps: Same process but apply to entire data range A2:D50 **Rule 3: Monthly Trend Indicators** - Description: Shows improving/declining performance with arrows - Use data bars or color scales for the revenue column to show relative performance - This creates an instant visual hierarchy for your data analysis.

Pro Tips for Best Results

Test your conditional formatting rules on a small data sample first to ensure they work correctly
Use color combinations that are accessible - avoid red/green only combinations for colorblind users
Start with the most important condition first, as later rules may override earlier ones
Use absolute cell references ($) in formulas when you want to compare against fixed ranges
Keep formatting subtle enough that the data remains readable - avoid overly bright colors