Excel guide · conditional formatting
Excel conditional formatting: highlight rows
Conditional formatting colors a cell by its value: an amount over the limit turns red, stock under the reorder level stands out. This guide covers Excel's ready rules, coloring a whole row with a formula and managing rules; then we add the same rule in Nexell with one sentence.
Free account · no card · 30 credits a month · Not ready to sign up? Paste some text and try it
Step by step
How to use conditional formatting in Excel
-
1
Select the range
Select the cells to color. To color whole rows, select the whole table without the header (A2:E9 below).
-
2
Pick a ready rule
Under Home > Conditional Formatting > Highlight Cells Rules you find Greater Than, Less Than, Between, Duplicate Values and more. Type the threshold and pick a color from the list.
-
3
Write a formula for the row
Choose New Rule > Use a formula to determine which cells to format and type =$D2<$E2. The $ before the letter makes every cell look at columns D and E; the row number has no $, so the rule tests its own row on every row.
-
4
Choose the format and manage it
Click Format, pick a Fill color and click OK. To edit or delete a rule, open Conditional Formatting > Manage Rules.
Example
Coloring the rows below the reorder level in Nexell
We pasted a stock list into the tool and typed two requests. The products are made up for the illustration.
1Pasted list
2In Nexell
- Text turned into a table: 5 columns, 8 rows. In Stock and Reorder Level came in as numbers.
- make the rows red where In Stock is less than Reorder LevelWhole row: rows where In Stock < Reorder Level highlighted in red
- add a data bar to the In Stock columnData bar added to the In Stock column
Each request came back as a preview first (it showed that no rows would be deleted, only formatting added); the table changed only after Apply.
3In Excel
6| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item Code | Product | Warehouse | In Stock | Reorder Level |
| 2 | A4-080 | Copy paper A4 | Main | 420 | 150 |
| 3 | KLM-MV | Ballpoint pen (blue) | Main | 85 | 120 |
| 4 | ZRF-110 | File envelope | Branch | 60 | 50 |
| 5 | TNR-305 | Toner (black) | Main | 6 | 10 |
| 6 | SPR-024 | Spiral notebook | Branch | 240 | 80 |
| 7 | YPS-012 | Sticky notes | Branch | 35 | 40 |
| 8 | KLS-050 | Binder (wide) | Main | 130 | 60 |
| 9 | TNR-305 | Toner (black) | Branch | 14 | 10 |
The colors are not painted onto the cells; the file holds two conditional formatting rules: a =$D2<$E2 formula rule on A2:E9 (light red fill, dark red text) and a green data bar on D2:D9. Change an In Stock value in Excel and the row color follows. Cost: 3 credits (the conversion plus two requests).
Illustrative example with made-up products and quantities; the rules shown are the kind Nexell writes into the downloaded file.
Why Nexell
What Nexell does differently
Excel's own rule
The color is not fixed onto the cell; it is written into the file as an Excel conditional formatting rule. When the value changes, the color changes with it.
No $ signs to fiddle with
The sentence “In Stock is less than Reorder Level” becomes a correctly anchored =$D2<$E2 rule applied to every row.
Preview, then apply
The request is shown on screen first; it is not applied to the table or the file until you approve. Every step can be undone.
Your file is not stored
The list is held only in server memory while it is processed, not written to disk, a database or logs. Personal data in text is masked before it is sent to the AI service (what is sent).
Limits
What to know before you start
- Check the preview when you color by date. A request like “make rows due before today red” can be mistaken for a filter; if the preview says rows would be deleted, do not click Apply. In Excel you can also use the rule =$C2<TODAY() in Excel.
- AI reads your request. Requests in many languages work; one that is not understood is not applied and costs no credits. Nexell's fallback engine, used when AI is unavailable, reads only English and Turkish.
- Size limits: Free plan tables up to 5,000 rows and files up to 10 MB.
FAQ
Conditional formatting: common questions
How do I highlight a whole row with conditional formatting in Excel?
Select the whole table without the header, open Home > Conditional Formatting > New Rule, choose the formula option and write the condition for the first data row: =$D2<$E2. Put the $ before the column letter and not before the row number, then pick a fill color under Format.
Do I need an IF formula in conditional formatting?
No. A rule formula is already a condition: write =$D2<$E2, and for several conditions use AND or OR, such as =AND($D2<$E2,$C2="Main").
Does the color Nexell adds update in Excel when a value changes?
Yes. The color is written as an Excel conditional formatting rule, not as a fixed fill. When you change a value the format is recalculated, and you can edit or delete the rule under Manage Rules.
How many credits does adding conditional formatting cost?
Turning text into a table and each request cost 1 credit per 1,000 rows. Downloading costs no credits (Free plan: 3 a month). The Free plan gives 30 credits a month, no card needed.
Related
More Excel jobs you can do by typing
- Pivot table in ExcelTotal a long list by region, month or product, step by step.
- Match two lists without VLOOKUPCompare two lists by a shared code, by typing.
- Excel formula generatorType what to calculate and let Nexell build the formula.
- VAT calculation in ExcelSplit a gross amount into net and VAT with live formulas.
- CSV to ExcelThe right delimiter, characters intact.
- PDF to ExcelTurn the table in a PDF report into a clean table before you color it.
Add the color rule without writing a formula.
Create a free account, paste your list and write the rule in one sentence.
Try it free