Conditional Formatting
Creates conditional formatting rules to highlight data.
AI Prompt Generator
Craft an optimized prompt for any LLM in seconds.
PDF, Word, Excel, CSV, text, Markdown, JSON, XML, HTML & code — up to 5 files, 10 MB each. Files are analyzed and never stored or shared.
Great all-rounder for writing, code and analysis.
What this tool does
Creates conditional formatting rules to highlight data.
When to use it
You want visual cues on your data.
Prompt template
Write the conditional formatting rule to [highlight condition] in range [range]. Give the formula and steps.
Example
Highlight rows where due date is past today.
Common mistakes to avoid
- Wrong absolute/relative references
- Applying to the wrong range
Best practices
- Specify the exact range
- Ask about relative references
Frequently asked questions
Do I need Microsoft Copilot to use this Excel tool?
No. You can generate the prompt here and paste it into ChatGPT, Claude, Gemini or Copilot. Copilot adds live access to your Excel file, which is convenient but optional.
Will the AI change my original file?
No. FormelyAI only generates text prompts. You copy the result and apply it yourself, so you stay in control of your documents.