---
title: "Highlight the whole row with $ | PracticeExcel"
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://practiceexcelonline.com/practice/conditional-formatting/highlight-whole-row"
locale: en
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://practiceexcelonline.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 $ | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.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://practiceexcelonline.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**

[**See plans, from $5/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/practice/conditional-formatting/highlight-whole-row)

Need help?

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.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://practiceexcelonline.com/practice/conditional-formatting/highlight-whole-row","breadcrumb":{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/highlight-whole-row#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/conditional-formatting/highlight-whole-row"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/highlight-whole-row#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"Conditional formatting","item":"https://practiceexcelonline.com/practice/conditional-formatting","position":3},{"@type":"ListItem","name":"Highlight the whole row with $","position":4}]},{"@id":"https://practiceexcelonline.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://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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