Highlight rows in Excel by a condition
Conditional formatting is a dialog per rule, and the rules travel with the sheet rather than with the data. Say what should be coloured and get a workbook where the colours are simply there.
The instruction to paste
Example instruction
Highlight the Status cell in red where the status is cancelled, and the Amount cell in green where Amount is at least 1200
What comes back
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| APAC | Beta | 340 | cancelled |
| EMEA | Gamma | 890 | overdue |
| AMER | Alpha | 1500 | paid |
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| APAC | Beta | 340 | cancelled |
| EMEA | Gamma | 890 | overdue |
| AMER | Alpha | 1500 | paid |
How it works
- 01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
- 02
Paste the instruction, changing the column names to the ones in your own file.
- 03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.
Other ways to ask
The instruction is read as a sentence, not filled into a form. These all work on the same file.
Colour the whole row light red where Status is cancelled
Make the Amount value bold where it is above the average for the file
The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.
Questions
Can I colour the whole row rather than one cell?
Yes — say "the whole row" and the fill covers every column in it.
How many rules can one instruction have?
As many as you need, in different colours, and they can apply to different columns.
Is this real formatting or conditional formatting?
Real fills and real bold, written into the cells. They survive being copied into another workbook, which conditional formatting rules often do not.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.