📊 Excel
beginner
⏱ 8 min
Set up conditional formatting rules using AI
Highlight overdue tasks, low inventory, or budget overruns automatically. AI gives you the exact rule settings to use.
Tools used:
ChatGPT
Microsoft Excel
Step-by-step walkthrough
-
1
Define what you want to highlight
Tell the AI what your column contains and what condition should trigger formatting.
💬 Prompt to use:I have a column called "Days Overdue" in column D. I want cells with values greater than 0 to turn red, and cells equal to 0 to turn green. Give me Excel conditional formatting instructions.
-
2
Open Conditional Formatting
Select your column, go to Home → Conditional Formatting → New Rule.
-
3
Follow the AI instructions
Enter the formula or rule values exactly as the AI specified. Set your fill colors.
-
4
Apply and test
Click OK. Verify a few cells to confirm the colors look right.
💡 Pro tip: You can layer multiple rules. Ask the AI for a second rule for "warning" status (e.g., values 1–3 in yellow).