---
title: "Highlight the whole row with $ | ExcelSavvy"
description: "Practice conditional formatting that highlights a whole row in Excel. Lock the column with $ in the rule's formula and get it checked right away."
canonical_url: "https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row"
meta:
  "og:description": "Practice conditional formatting that highlights a whole row in Excel. Lock the column with $ in the rule's formula and get it checked right away."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~SGlnaGxpZ2h0IHRoZSB3aG9sZSByb3cgd2l0aCAk%2Cdescription_~UHJhY3RpY2UgY29uZGl0aW9uYWwgZm9ybWF0dGluZyB0aGF0IGhpZ2hsaWdodHMgYSB3aG9sZSByb3cgaW4gRXhjZWwuIExvY2sgdGhlIGNvbHVtbiB3aXRoICQgaW4gdGhlIHJ1bGUncyBmb3JtdWxhIGFuZCBnZXQgaXQgY2hlY2tlZCByaWdodCBhd2F5Lg%2Ceyebrow_Conditional%2Bformatting%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZXAiLCJSZWdpb24iLCJTYWxlcyIsIlJ1bGUiXX0seyJuIjoyLCJjZWxscyI6WyJMYXJzIiwiTm9ydGgiLCIxMjUwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9jb25kaXRpb25hbC1mb3JtYXR0aW5nL2hpZ2hsaWdodC13aG9sZS1yb3ci%2Cs_w4vEKKFdozQYwhef.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Highlight the whole row with $ | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~SGlnaGxpZ2h0IHRoZSB3aG9sZSByb3cgd2l0aCAk%2Cdescription_~UHJhY3RpY2UgY29uZGl0aW9uYWwgZm9ybWF0dGluZyB0aGF0IGhpZ2hsaWdodHMgYSB3aG9sZSByb3cgaW4gRXhjZWwuIExvY2sgdGhlIGNvbHVtbiB3aXRoICQgaW4gdGhlIHJ1bGUncyBmb3JtdWxhIGFuZCBnZXQgaXQgY2hlY2tlZCByaWdodCBhd2F5Lg%2Ceyebrow_Conditional%2Bformatting%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJSZXAiLCJSZWdpb24iLCJTYWxlcyIsIlJ1bGUiXX0seyJuIjoyLCJjZWxscyI6WyJMYXJzIiwiTm9ydGgiLCIxMjUwMCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9jb25kaXRpb25hbC1mb3JtYXR0aW5nL2hpZ2hsaWdodC13aG9sZS1yb3ci%2Cs_w4vEKKFdozQYwhef.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **Highlight the whole row with $**

**Premium**

You selected A2:C20 and want to highlight the whole row when sales are over 10,000. In D2, write the rule so every cell in the row tests column C. Lock the column with $, but not the row.

D2fx

|  | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Rep | Region | Sales | Rule |  | |
| 2 | Lars | North | 12500 |  |  | |
| 3 |  |  |  |  |  | |
| 4 |  |  |  |  |  | |
| 5 |  |  |  |  |  | |
| 6 |  |  |  |  |  | |
| 7 |  |  |  |  |  | |
| 8 |  |  |  |  |  | |

**Premium lesson**

## **Unlock Conditional formatting and every other lesson**

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:**Drop-down lists and data validation****COUNTIF**

**Your first month for $9.50 **~~$19~~

50% off your first month when you join today.

[**Get your first month for $9.50**](https://excelsavvy.com/signup?next=/pricing?plan=monthly%26go=1%26offer=FIRSTMONTH)

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

[**See all plans, from $5/month**](https://excelsavvy.com/pricing)

[**Already premium? Sign in**](https://excelsavvy.com/login?next=/practice/conditional-formatting/highlight-whole-row)

Need help?

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row#webpage","@type":"WebPage","description":"Practice conditional formatting that highlights a whole row in Excel. Lock the column with $ in the rule's formula and get it checked right away.","name":"Highlight the whole row with $","url":"https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row","breadcrumb":{"@id":"https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"Conditional formatting","item":"https://excelsavvy.com/practice/conditional-formatting","position":3},{"@type":"ListItem","name":"Highlight the whole row with $","position":4}]},{"@id":"https://excelsavvy.com/practice/conditional-formatting/highlight-whole-row#/schema/learning-resource/1","@type":"LearningResource","description":"Practice conditional formatting that highlights a whole row in Excel. Lock the column with $ in the rule's formula and get it checked right away.","educationalLevel":"intermediate","isAccessibleForFree":false,"learningResourceType":"exercise","name":"Highlight the whole row with $","teaches":"Conditional formatting"},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
