Skip to content

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. 1

    Select the range

    Select the cells to color. To color whole rows, select the whole table without the header (A2:E9 below).

  2. 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. 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. 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

  1. Text turned into a table: 5 columns, 8 rows. In Stock and Reorder Level came in as numbers.
  2. make the rows red where In Stock is less than Reorder LevelWhole row: rows where In Stock < Reorder Level highlighted in red
  3. 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

D5fx6
The Data sheet of the downloaded Excel file: red rows where In Stock is below Reorder Level, with a data bar in the In Stock column
ABCDE
1Item CodeProductWarehouseIn StockReorder Level
2A4-080Copy paper A4Main420150
3KLM-MVBallpoint pen (blue)Main85120
4ZRF-110File envelopeBranch6050
5TNR-305Toner (black)Main610
6SPR-024Spiral notebookBranch24080
7YPS-012Sticky notesBranch3540
8KLS-050Binder (wide)Main13060
9TNR-305Toner (black)Branch1410
DataChart

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.

Inventory status dashboard in Excel

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.

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