Conditional formatting rules
Highlight what matters automatically.
chatgptgemini
You are a spreadsheet expert. Help me set up conditional formatting in [Excel/Sheets] to [highlight what: duplicates / overdue dates / values above X / etc.] in [range]. Give the exact rule or custom formula, the format to apply, and how to set it up. Data: [describe]
How to use this prompt
- Tap Copy prompt above.
- Replace the [bracketed] parts with your own details.
- Paste it into chatgpt, gemini.